RE: [PHP-DB] Mysql completing Query fast but mysql->query() takes long time to return even single selects/updates

2010-04-12 Thread David Murphy
ginal Message- From: Chris [mailto:dmag...@gmail.com] Sent: Sunday, April 11, 2010 6:26 PM To: David Murphy Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Mysql completing Query fast but mysql->query() takes long time to return even single selects/updates David Murphy wrote: > As you c

Re: [PHP-DB] Mysql completing Query fast but mysql->query() takes long time to return even single selects/updates

2010-04-11 Thread kranthi
just a pointer.. have you enabled php profiling to see if it actually mysql->query() that takes 20 secs ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Mysql completing Query fast but mysql->query() takes long time to return even single selects/updates

2010-04-11 Thread Chris
David Murphy wrote: As you can see PHP claims it took 20 seconds for mysql->query() to return but mysql think is took around 1.0s This is from our application I enabled profile in mysql to determine why an update took 20seconds. As you can see MySQL reported no where near that amount o

[PHP-DB] Mysql completing Query fast but mysql->query() takes long time to return even single selects/updates

2010-04-09 Thread David Murphy
As you can see PHP claims it took 20 seconds for mysql->query() to return but mysql think is took around 1.0s This is from our application I enabled profile in mysql to determine why an update took 20seconds. As you can see MySQL reported no where near that amount of duration took place.