number of sql queries high

[Rosey]

I noticed something that might be the issue of my slowness on my forum.

The number of sql queries is outrageously high (5000+). It wasn't always like that but we moved to a new server.

I did optimize the db. Anything else I can do?

[Page generation time: 20.8045s (PHP: 17% | SQL: 83%) | SQL queries: 5829 | GZIP enabled | Debug off]

[BobT]

Sorry i do not have a fix but i do share your problem but not as severe. I am in the 800+ range.

When i first moved my server and files to a new host, queries were normal, then out of the blue i was hitting 800 queries. The slowness of the server might be linked to your server hitting your limit if you are a shared server. I was experiencing this and it was the reason for my move to a dedicated server. On my site ( http://www.nycichlids.com ) my loading time are OK even with the 800+queries ... on my shared server loading times were 20 sec or more ... a 15 sec loading time was great .. hehehe.

It has been suggested to me that sql and php are in a loop and your 5000 queries are the same hits ... I am still in php/sql 101 ... Good luck finding a fix, i will be looking at this thread closely.

[Rosey]

in a loop because of the host or the board?

[binh.tang]

Rosey,

I had that problem for quite some time but luckily as I was a dedicated server, didn't make too much of an impact (though still slow on my site too).

I found the biggest problem was some tables in the database didn't have any INDEX on them, so it make the queries slower as it had no index on that table to search for information so it had to go through the whole table. If you have a large table with thousands or records, this could take awhile.

I'm no database guru, but since going through all the tables from myphpadmin and creating at least one index on that table has made a huge difference.

Hopefully that helps.