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?

1-20-05, 01:51 PM	#1
notset4life Join Date: Feb 2002 Posts: 352 Reputation: 27	SQL Queries VERY slow 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.

1-21-05, 09:30 AM	#3
Pig foo Join Date: Jan 2003 Location: Seattle-ish Posts: 2,597 Reputation: 106	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? __________________ webhead.cc

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

1-20-05, 03:54 PM	#2
mitchind Older not wiser Join Date: Nov 2003 Location: Calgary, AB Posts: 2,473 Reputation: 205	What MySQL server are you on? Things have been a lot smoother for a couple of days now for my sites.