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.

[weewilly]

I installed this hack and it seemed to work OK.

Until.... you entered a forum and then clicked on a thread to view it. Then, an error was displayed. I had to upload the original file to correct it.

I am using version 2.3.2

Anyone have any idea why this is not working for me? I am an extreme novice and feel silly even posting this.

*********************

Edited to add:

I have it working now. I was editing the file in dreamweaver. When I switched to notepad I was able to modify it and get it working.

[Alien]

Wow, people are really sleeping the past few months...

Help!

[Alien]

Ok I've decided to temporarily remove the other hack while I work it out. In the meantime I've installed this one, and the additional query removal from fury and all is working properly so far.. I'll let you know if it breaks anything.

Nice work you guys!

[julius]

Installed on vB 2.3.2.

Thanks

[legendarysk8er]

Working fine ob vB 2.3.2.

/me clicks install.

[zsmom]

Works great on 2.3.2. Thanks!!

* zsmom clicks install.

[luke2kz71]

installed on 2.3.4 and working great!