[Brad]

Originally Posted by filburt1

vB3 also has vBCron so some queries just aren't performed immediately.

Just adding to this, A good example of the new 'vBcron' system is seen in the view counts on forumdisplay. They are updated every hour or so. I use a hack that put the new views in a HEAP table then writes them to the threads every 400 pageviews when the server load is not to high. Heres the lastest email i got from my board about the stats:

841 Total Views (original number of write queries)
48 Threads (new number of write queries)

94% of Writes Avoided [793 avoided]
18:1 Original Writes vs. Consolidated Writes

I think that speaks for itself, look at how many write where saved