How many queries are too many?
 

I just installed a hack that shows the time it took to generate a page, and it also shows how many queries are taking place on that page.

On my front page I have 92 queries.
On forum pages I have 23 queries.
Inside a thread I have between 28 and 32 queries.

What exactly accounts for queries? How much do they slow down the pages, and should I be worried that my front page has soo many?

If somebody could get me in the know I would greatly appreciate it.

Thanks.

A query is what sent to the MySQL server in order to get data from the database.
The more queries you have, the slower the page will be. 92 queries on the front is a huge number, my guess is that you have some messed up which queries the database for every forum you have.

If you look in the stats, you will usually see most of the time the page is doing MySQL stuff, and the time it wastes on PHP is much smaller.

FireFly, do you have any suggestions on what I can do or where I could start to find out why there are soo many? I really need to make my forum as much as possible, non server intensive.

If you can help me or give me some pointers on where to start I would greatly appreciate it.

Thanks.

Which forum are you talking about? I can take a look at the queries and see what's wrong.

Here's the front page: http://www.theforumz.com/forumz/index.php?s=

that has 93 queries. Could it be all the hacks I have installed and that I haven't messed anything up?

It has 22 queries:
http://www.theforumz.com/forumz/index.php?s=&explain=1
The hack is lying.

How do you know? When I go to that explained thing I got this when I scroll past a huge page of details.

How did you find out there is only 22?

I think these queries are only made for Admins, Mods, or, fairly likely, logged in users...but not people like Chen or I or whomever.

hmm, so WTH is the forum doing for mods and admins that adds soo many more queries? I mean, maybe a dropdown box at the bottom of the page, but that's about it. :confused:

Setup a test account we can use.