Originally Posted by
Diftraku
I'm assuming Vbulletin has built-in support for APC/Memcached? If not then please do tell me Vbulletin has some sort of caching system in place.
The page count shouldn't be that bad, really. Assuming the board is doing it correctly and doing a query along the lines of SELECT * FROM posts WHERE `threadID` = '893666' AND `deleted` = '0' LIMIT 0, 20; (I'm assuming a lot of things here and doing it mostly in pseudo SQL, for example: the limit should start from last post ID on previous page, instead of all the posts and assuming threadID is an index along with post state, using deleted as a on/off state since I don't remember how it worked in phpBB). Then again, MySQL is just silly DB platform...