Re: Database connections

Ryan A wrote:

Hi, I have almost finished making a set of scripts that would communicate with maybe 1k sites to start with... I'm sorry I cannot give you more details about the scripts but this guy is really nervious and had me sign an NDA etc etc but what i would like to know is; would there be a problem with connecting to the database many hundred/thousand times a minute? (esp on a shared server as this guy and I cannot afford a dedicated at this point)

On a shared server? Most likely yes. Either you'll kill the mysql server (for everyone) or they will have you set up with limited connections. I'm assuming you're using a mysql database: http://dev.mysql.com/doc/refman/5.0/en/grant.html <-- see MAX_CONNECTIONS_PER_HOUR http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html Other databases will have similar limitations. I hope you're not connecting/disconnecting between queries... -- Postgresql & php tutorials http://www.designmagick.com/