painfully slow db access

[tgwhnn]

Hello,

 

Any suggestion will be appreciated, although this could be more of a mysql + php problem. I have windows 2000 and I'm running php4.4.0 + osc + mysql4.1 ALL ON LOCALHOST and for some strange reasons, db access are painfully slow to a point where any productivity is impossible. I've timed the mysql_query call in tep_db_query in database.php and came back with unacceptable results such as:

 

11.3739 seconds: select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

3.1993 seconds: select configuration_id, configuration_title, configuration_value, use_function from configuration where configuration_group_id = '1' order by sort_order

 

Because each page runs about 20 to 30 queries, on the average it takes about 45 seconds to 1 min to load a page. Frequently, it takes more than 2 mins. I know that because i bumped up the max_execution_time in php.ini to 120 and was still getting the "Maximum execution time of 120 seconds exceeded..." in the error.log. Another setting i've changed was memory_limit from 8M to 16M. With that, things still didn't change much. Oh well..

 

Maybe there're some settings i missed? Please help! Thanks :)

[Guest]

ok i am using localhost here too and goes like a charm. Have you setup a test php page without sql to see if its really the dbase access? If that's ok setup with phpmyadmin a small dbase and with a couple of queries see if that goes smooth.

[tgwhnn]

Actually, php pages without any db actions are running pretty fast. Just checked again. I also entered the same db queries directly from the mysql> command prompt and the results return fast as well. So at this point i'm tempted to conclude that the bottleneck resides in php to mysql communications. Maybe something is not working and is hitting the timeout?? Anyhow, if you have any more thoughts hit me back! Thanks :)

[Guest]

could be your host has the server you are on is overloaded. some hosts dont let many people on the servers, which is why they would charge more.