Thread

Hello.. How can I check if I am closing the mysql connections properly, my site is awfully slow and it takes forever to load. Please help.

Thanks.

You can start of by turning template debugging under CP Home ›  Admin ›  System Preferences ›  Output and Debugging Preferences. Good start is clearing cache.

Keep in mind there is tons of variables that can cause the site slowdowns from web server, connection and traffic, shared host and mysql server etc. etc.
Now when you say:
“How can I check if I am closing the mysql connections properly…”
does this mean you are running so of your own php code against mysql?

You can also look through forums for keyword “performance” to compare notes with other users that have experienced issues.
In the meantime go through this checklist.

Hello Lebisol, thank you very much for your reply. Yes, the template debugging is turned off. I have tried clearing the cache also and the host is a shared host.

My concern is that the test website which is the clone of the production is much faster and it never gives the error message; where as the production site waits for a lot of seconds and the status message reads-“waiting for http://www.someurl.com” or “connecting to http://www.someurl.com” and then the website is not displayed at all. When I try refreshing it a few times, then it shows up. What could be causing this problem?

Thanks again for your time.

Best.

Turn it on and see/share the output. This is something that EE staff would read with more understanding then me.
This should give you some idea to ‘what is taking so long’.

Another comparable test would be making a simple template and just pulling say 1 entry to see how long it takes. Then pull the some info/record with just php.
In essence see if it is the EE or the server itself.