Re: Database connections

Ryan A wrote:

Hi Phillip/Chris, Thanks for replying. Other than actually asking the host and taking a chance of pissing them off before i have even done anything....is there any way to find out the max connections by looking at the phpinfo() ?

If you have phpmyadmin or something installed: show status like '%connection%'; should show something.

/* I hope you're not connecting/disconnecting between queries... */ Unfortunatly i have to....for each site, the more sites...the more querying :-(

If they're accessing the same database you don't need to disconnect/reconnect. Different db's - well, yeh you don't have a choice.

Suggestions welcome..

Without knowing what you're doing or what queries you're running we can't really help.. and you can't tell us 'coz of the NDA.. so I guess we're stuck ;) -- Postgresql & php tutorials http://www.designmagick.com/