![]() |
Thread view optimizations
This is a little hack that I did to improve the speed at which threads are
loading in my forums. I am experiencing very high server loads due to the limited hardware on the server and due to the high post counts in my forums. This hack has tremendously sped up showthread.php. In order to view an entire thread, showthread.php makes 3 queries into the post table. I have managed to divert one of these queries to the thread table, and have managed to combine the remaining 2 queries into a single query. The thread table is usually 10%-15% of the post table in terms of count, and it is about 5% of the post table in terms of its physical size. Using the thread table for one of the queries will definitely improve things. This hack requires no template or table changes. It is just 3 simple code changes made to the source code. |
looks nice :D will instlal
[high]* Hobbes clicks instlal when he finishes[/high] |
How about some benchmark statistics, by curiousity? ;)
What was the loading time before, and what is it now? (that is, if you have Teck's microstats installed) |
I'll install this...speed is good. :)
*mx3 clicks install |
I'd like to see some stats too :)
|
Loading a bit faster for me :)
|
Quote:
Perhaps someone with somewhat larger threads could post some stats.. |
Page generated in 0.61381495 seconds (81.33% PHP - 18.67% MySQL) with 25 queries.
Page generated in 0.41559005 seconds (80.16% PHP - 19.84% MySQL) with 24 queries. it loads fast i suppose. l8er sonic |
Always nice to drop a query when installing a mod instead of gain one..
Nice work :) |
So far its working nice. Why didnt vBulletin do this? Is there some sort of draw back?
|
All times are GMT. The time now is 12:35 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|