[jarosciak]

Originally Posted by zenkaizen

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.

Same problem on my forum. I am running these stats on a forum with just little over 300k posts and it's basically killing it. It adds up good 3-5 additional seconds to display the main page.

And consider, that this forum is the only website on a very strong dedicated server.
It shouldn't take a more than split of a second to get these stats, so why doesn't it work properly?

Whenever someone hits the main page, this script would use almost 100% of 3gh dual pentium cpu power.

As soon as I disable it, the whole forum is flying like usually.

I don't want to get rid of these stats as me and all my members got used to it, and it's a truly awesome script, but someone should look at this issue and let us know what is happening.

Anyhow, to give you little more details...I am only showing Top Posters, Newest Members and Latest Posts.

I have also removed AND `visible` = '1' and AND `open`!='10' from the WHERE clause and it helped a little bit. But still taking crazy lot of time to generate the front page stats.