Hi, Pages of my PHP site are loading mega slow, 50 second page load for a page which should load in <1 sec. I told my ISP, and they have blamed 'incorrect scripting.' IE Reports no javascript errors, none are shown in the pages and Apache logs no PHP errors etc. How can I trace this? I have tried removing the javascript, has no effect. How can I trace this? Thanks.
According to my ISP, server load is 'normal'. They blamed my script as my other html script on the same server loads fine. I said that this means nothing as it could be a problem with PHP/MySQL. How can I test for MySQL problems etc?
It's a bit difficult to test mysql if you are a shared host, which I am assuming. I also assume that your script was working fine and fast at some point? Do you know if your server had crashed recently? Because that can cause mysql to corrupt. Maybe you can try optimizing your database? Do you have access to phpmyadmin? You can select the database from there, check all tables and at the bottom, click optimize. If your database is large, let's say larger than 100mb, phpmyadmin may time-out before this completes. I always hate it when hosts automatically blame the script.. usually it's laziness
You're right: Hey presto, pages now load in 1 second rather that 50 seconds. I estimate that bouce rate could at least half. And conversion rate should increase too. Damn ISPs!!!