Hi guys, i'm running image gallery site and recently noticed that once number of online visitors approaches 20, site's pages open really slowly. I wrote to hosting company to find out the reasons and that's the answer:
"Dear Customer,
you do have a number of slow mysql query logs you should check out under the tmp folder. I see quite a few select * queries with nothing else specified which is most likely going to be pretty heavy query on the server but the site loads extremely fast for me inside and out of our network. The server is not under heavy load and looks good so the only probable issue would be a connection issue or the optimization of your sites and sql queries."
I'm now totally stuck not knowing what to do next (( Can you please just show me right direction to move forward ?
Comments
=-=
In future please tag your thread with the version of drupal in use. It aids in trying to guide you to fix your issues.
devel.module can help diagnose which querries are considered slow.
there are multiple optimization techniques that can be employed. visit 2bits.com and the performance group at groups.drupal.org
If you are on a shared server, you may not be able to employ some of the optimizations.
I'd suggest running devel on your localmachine using an export of your current database so as not to slow down the site any more then necessary.