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.

[Hobbes]

looks nice will instlal

[high]* Hobbes clicks instlal when he finishes[/high]

[Velocd]

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)

[mx3]

I'll install this...speed is good.

*mx3 clicks install

[jdmuniverse]

I'd like to see some stats too

[mx3]

Loading a bit faster for me

[Pikok]

Yesterday at 11:25 PM Velocd said this in Post #3
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)

Before:

• Page generated in 1.02129197 seconds (86.35% PHP - 13.65% MySQL) with 28 queries. [GZIP enabled - level 1]

After:

• Page generated in 1.00562406 seconds (86.31% PHP - 13.69% MySQL) with 27 queries. [GZIP enabled - level 1]

I would think that the savings would be more noticeable for larger threads with numerous replies. The above stats are for a thread with only 2 replies (3 posts total). I think the larger the thread, the more noticeable the increase will be. But, even with a small thread I noticed an increase in speed. It does work! Thanks Zzed!

Perhaps someone with somewhat larger threads could post some stats..

[sonic3d]

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

[Oblivion Knight]

Always nice to drop a query when installing a mod instead of gain one..

Nice work

[Dolby]

So far its working nice. Why didnt vBulletin do this? Is there some sort of draw back?