The Design of Software (CLOSED)

A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.

The "Design of Software" discussion group has been merged with the main Joel on Software discussion group.

The archives will remain online indefinitely.

Best way to manage DB connections with PHP and lots of users?

I'm working on an internal app that will eventually have a couple of thousand users connecting via a webpage or an XML-RPC webservice.

How do I manage how many connections get created and used? Write a broker process? Or use some PHP-magic?

Now I haven't done too much web development in the past, and I know this problem has been "solved" before. Any pointers to docs would be appreciated.
PHPNewbie Send private email
Sunday, August 21, 2005
What database product will you be using?  PHP has built-in connection pooling (a.k.a. persistent connections) for some databases.  For MySQL and PostgreSQL, it's as simple as using the mysql_pconnect() function to establish a database connectinon, instead of the standard mysql_connect() function.
Ryan Send private email
Sunday, August 21, 2005
I'll either be using PostegreSQL or DB2. I'll check out the pooling thing.
PHPNewbie Send private email
Monday, August 22, 2005

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
Powered by FogBugz