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.

[Darkwaltz]

Nice, easy to install and speeds up my pages a lot

*install*

[MrNase]

:bunny: wow! loads a lot faster, thx

clicking install....

[pwr_sneak]

Today at 08:36 AM Dolby said this in Post #10
So far its working nice. Why didnt vBulletin do this? Is there some sort of draw back?

they didn't implement this because it would not work for forums which moderate new posts.
but you could use $forum['moderatenew'] to decide which version you wanted to use.

if ($forum['moderatenew']) {
//use old queries
}
else {
//use faster queries
}

[ed2k_2]

Installed without any problem. Threads load more faster!
Thanks Zzed!

[Dean C]

Same here !

[corsacrazy]

Today at 05:21 PM Mist said this in Post #15
Same here !

where to ? :ermm:

[Dean C]

My forums are private

[oldgamesnu]

Before: in 0.24841595
After: 0.20439696

[fury]

07-30-03 at 07:04 AM pwr_sneak said this in Post #13
they didn't implement this because it would not work for forums which moderate new posts.
but you could use $forum['moderatenew'] to decide which version you wanted to use.

if ($forum['moderatenew']) {
//use old queries
}
else {
//use faster queries
}

Why not just change this line...

$postids.= "post.threadid='$threadid'";

to this:

$postids.= "post.threadid='$threadid' AND post.visible='1'";

It might slow it down a tiny bit more but it works with moderated forums...

[fury]

BTW, this (after you've applied the mod)

$postscount=$DB_site->query_first("SELECT replycount AS posts FROM thread WHERE threadid='$threadid'");
$postscount[posts]++;
$totalposts=$postscount[posts];

can be replaced, to save yet another query, with this:

$totalposts = $thread['replycount'] + 1;

since the thread info is already fetched earlier in the file.