|
| Register now to interact with over 11,000 members! Registered users have Posting Privileges, free access to Private Messaging, Email Notifications and more. |
|
|||||||
![]() |
|
|
Thread Tools | Search this Thread |
|
|
#1 |
|
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. |
|
|
|
|
#2 |
|
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. |
|
|
|
|
#3 |
|
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 |
|
|