[slinky]

I was wondering if there is any way to cut down on this incredible plugin being the resource hog that it is. It's practically 1/3 the size of the entire vBulletin database. That itself is of concern. I don't really need all the daily feeds, etc. who did what, etc. They just need a few toplists and that's all. Those can and should be cached and can be updated daily and would be fine (e.g. "List as of xx/yy/zzzz).

But here's a larger issue. I started to log slow queries and this is what I saw - not even what I expected. The first two queries have been shown several times in the list. Perhaps we can put together a practices list for minimizing resources using this plugin? If it was already done, would someone be able to point me to it? Many thanks - here's my data:

# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 664253
use mysite_mysitedb;
SELECT
COUNT(*) AS cnt_ach,
i.achievementid,
a.title,
a.description,
a.imagebig
FROM xperience_achievements_issues AS i
INNER JOIN xperience_achievements AS a ON a.achievementid=i.achievementid
GROUP BY achievementid
ORDER BY COUNT(*) DESC
LIMIT 1;
# Time: 120128 14:34:46
# User@Host: mysite_myaccount[mysite_myaccount] @ [123.123.123.123]
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 664253
SELECT
COUNT(*) AS cnt_ach,
i.achievementid,
a.title,
a.description,
a.imagebig
FROM xperience_achievements_issues AS i
INNER JOIN xperience_achievements AS a ON a.achievementid=i.achievementid
GROUP BY achievementid
ORDER BY COUNT(*) ASC
LIMIT 1;
# Time: 120128 15:05:40
# User@Host: mysite_myaccount[mysite_myaccount] @ [123.123.123.123]
# Query_time: 5 Lock_time: 0 Rows_sent: 17 Rows_examined: 17
SELECT *
FROM datastore
WHERE title IN ('smiliecache','bbcodecache','mailqueue','bookmark sitecache','options','bitfield s','attachmentcache','forumcache','usergroupcache' ,'stylecache','languagecache', 'products','pluginlist','cron','profilefield','loa dcache','noticecache');