[Erwin]

Originally posted by Nakkid
is impossible. a showthread have 22 queries. unless you removed certain functions, you cant have 18queries. and your hacks you have installed dont perform any queries.
a showthread have 18-19queries when is an empty thread (no threads posted in the last 30days). as soon as you post once, it pops to 22.

firefly (who i'm pretty sure he started slowly to implement on this board vb3 code technique) have it at 29queries.

Oh, I missed the last few juicy posts!

It is possible, but only if you remove a few standard features.

I took out invisibility (that's 1), and forumjump (that's 2). The hacks in my showthread did not do queries.

Since then though, I have moved servers, and with a faster server I have put back forumjump, and reinstalled who is browsing this thread. I also reinstalled the "Users Online in Header".

This has brought my showthread back up to 23. (Page generated in 1.00907195 seconds (67.16% PHP - 32.84% MySQL) with 23 queries.)

My index is now at 17 queries. (Page generated in 0.29747605 seconds (82.73% PHP - 17.27% MySQL) with 17 queries.) - I did this by combining the PM queries, removing the query to count threads (I only display posts), and also keeping invisibility off. But using the "Users Online in Header" adds an extra 2 queries to every page.