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:
Quote:
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
03-11-2003, 10:49 PM
Threaded Mode