Little itty bitty question. Have queries been reduced or something on the vb 3 forums recently. Or in general. VBT is loading unusually too fast at moment for me...
Yes, the query count on most, if not all pages has been lowered. Remember however, that sometimes more queries can equal faster, it just depends on how server intensive said queries are. Ive done alot of custimization to my vB 2.3.0 RC forum, i droped a few queries on some pages to make it load faster, i split some large ones on others to speed it up.
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
Around 10-12 on forumhome I believe, down from what was originally 15-20.
Wow, 10-12 = Cool. My biggest were always showthread.php and newreply so maybe that'll be faster as well. Thanks for explaining things to me. Has anyone else though noticed some speed increases here at VBT?
03-11-2003, 10:37 PM
Queries...
Linear Mode
