This seems really fantastic, and I have installed it already, but so far I've gotten no e-mails whatsoever. Since my whole site is built around vBulletin 1000 or so threadviews should happen pretty quick. I get around 10,000-12,000 page views every day! Any clue of why I didn't get any e-mails with the stats? Thanks a lot!

The only reason you wouldn't get the emails is if your server load is consistently above 2.0. Login to the Admin CP and check your current load.


Also, check the my_threadviews table via PHPmyadmin to make sure it's being written to.

Ok, I just got several e-mails today, so this is definately working. Been getting anywhere from 40-80% avoided queries. Most of them around the 70% mark. Definately an AWESOME hack, this should be in vB 3.x!

Thanks a lot for such a great hack and for your help!

Glad to be of help. :)


BTW, the server my machine is on has been running at >5 load avg all day, and the temp table's got 14000 rows in it.... that's gonna be one crazy update. Will post when I get the email. :paranoid:

Jujubee,

What has been the response at VO? Are they taking notice of the extraordinary steps you have taken to lessen the load?

Cheers,

~Regs.

PMed you -- don't want to throw off this thread. :)

Latest email from 24-hour period:

For the statisticians out there, this is a 39:1 ratio of original queries versus consolidated queries. Which in english means there were originally 39 times the number of queries the were actually written to the disk.

This sounds like a good hack but is there a way to decouple it from sever load and make it just write periodically?

For whatever reason the server load monitoring doesn't work on my server. However I would like to be able to reduce the load.

Easy:

Find and remove " $loadavg[0]<2 && "

Jujubee, a great hack! Devs, should really consider making something similar as part of VB3.

But if your load is so high, why not just disable views? They're not all that important if you're having server load problems.