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

Re: [PHP-DB] phpmailer/mysql/ timout issues

2010-04-11 Thread Chris
ad wrote: I'm running php 5.1.6 with mysql 5.0.45 on CentOS 5.3 box trying to loop through a while statement to send about 3000 email using phpmailer. It's worked well in the past but after an upgrade it seems to be timing out now After an upgrade of what? php? mysql? phpmailer? the whole o/