Originally Posted by zenkaizen (Post 1405650)

This is a really useful mod, however I found that it slows down my forum index a lot. Normal load time without the mod installed is around 0.2 to 0.3s, and with the mod installed its around 1.6 to 2.3s. Currently using the Top 5 Hottest Threads, Most Viewed Threads, and Latest Posts.

After playing around with the queries, I found that removing AND `visible` = '1' and AND `open`!='10' from the WHERE clause speeds up the mod a lot. I'm wondering if there's any bad effects by doing this? Or do you have another suggestion to further optimize the queries.

The ideal way will be to cache them every x minutes or every hour. Pulling the stats dynamically all the time really slows down the forum index.

FYI: We're on a dedicated server with 200-300 online users during peak hours. The database is stored on an external server. Using vBMicroStats, with the mod enabled the load time is around 10% on PHP and 90% on MySQL. Without the mod, it's almost 50-50.