PDA

View Full Version : SQL Queries VERY slow


notset4life
1-20-05, 01:51 PM
I'm on Magnatar and it has been well documented in the forums about the issue of slow loading web sites. I don't know if the problem has been resolved, but parts of my PHP pages load pretty quickly, but the rest, where queries to the database are involved take about 20 to 30 seconds to load.
This is not acceptable.

I don't know if this is a powweb issue, or if it's something I can resolve in my php.ini file, or through the use of third party solutions, but I need quicker loading pages.

Can anyone provide thoughts, or comments on this issue, and/or how to accelarate php pages with a lot of queries?

Thank you.

mitchind
1-20-05, 03:54 PM
What MySQL server are you on?
Things have been a lot smoother for a couple of days now for my sites.

Pig
1-21-05, 09:30 AM
Are you certain that the lag is from mysql? Have you done any micro timers are to verify? Are you doing any file includes() or other file functions?