Re: long PHP mysql_connect times

2005-03-18 Thread Dan Tappin
On Mar 18, 2005, at 4:16 AM, Daniel Hawker wrote: Curiouser and curiouser said Alice... When you say *it seems to be the first connect* do you mean in a page, ie the first connect/disconnect takes ages but then any subsequent connects are fine) Exactly. If I use pconnect the first one takes on

Re: long PHP mysql_connect times

2005-03-18 Thread Jeremy Cole
Restating apache resets the issue i.e. the next pconnects takes 5 seconds. Quitting the browser has no effect. I am currently testing now to see if there is a time out issue i.e. if I wait 5 minutes will the delay reappear? FWIW, this sounds like a slow-to-respond DNS resolver. Are Apache

Re: long PHP mysql_connect times [Resolved]

2005-03-18 Thread Dan Tappin
Thanks Jeremy! It was the lack of a reverse DNS entry. I had the host resolved to an IP but now reverse arpa entry. I added the DNS PTR record and viola! I would have never though of / figured that one out. Dan T On Mar 18, 2005, at 10:59 AM, Jeremy Cole wrote: Restating apache resets the

Re: long PHP mysql_connect times [Resolved]

2005-03-18 Thread Jeremy Cole
Hi Dan, It was the lack of a reverse DNS entry. I had the host resolved to an IP but now reverse arpa entry. I added the DNS PTR record and viola! Excellent. Also FWIW, you're not gaining anything by disconnecting after each query in your PHP code. Connect once at the beginning of the script,

long PHP mysql_connect times

2005-03-17 Thread Dan Tappin
I'm not sure if it's a OS X, PHP or MySQL issue so I apologize in advance if this is taken as too off topic. I have a PHP5.x site under development with MySQL 4.1.10. I had the site running fine and there were no speed issues at all. Everything is on the same system (a dual G5 Xserve).