I think that generally PHP closes any non-persistent connections for you when you leave your script, so that it's not necessary to clean up after your script is done. You can create persistent connections, but in a high-traffic site they tend to become a resource problem after a while--and your server will be able to maintain only a finite number of connections open anyway. IMHO, before worrying about keeping the connections open, it's a good idea to take a good look at your setup and determine whether there are ways to improve upon its design. For example, you can use replication and have an instance of MySQL running on each web server, so that all database connections are local and performed through UNIX sockets, which are generally the fastest (assuming you're running UNIX, of course). This may require a bit of data redesign, but it's worked for me in the past. Marco -- ------------ php|architect - The magazine for PHP Professionals The monthly worldwide magazine dedicated to PHP programmers Come visit us at http://www.phparch.com!
--- Begin Message ---
- To: <php-db@lists.php.net>
- Subject: Database Connections
- From: "Bill Arbuckle, Jr." <bill@wingshooter.net>
- Date: Fri, 29 Nov 2002 09:43:05 -0600
- Delivered-to: mailing list php-db@lists.php.net
- Importance: Normal
I have a general question concerning databases in php. More specifically, what is the general consensus on maintaining a connection. Some of this is more than likely my ignorance. My connection stuff goes something like this ... $db = mysql_connect("localhost", "stuff", "pw") or die("Could Not Connect"); mysql_select_db("stuff",$db) or die("Could Not Select Database"); <<< Other Code Here >>> mysql_free_result($result); mysql_close($db); It seems very inefficient to open and close a database with each different page or call to that database. My question is ... Is there a better way and, if so, what is it? I guess I do not quite understand just how long a connection is maintained. I hate to write code that doesn't clean up after itself. Any suggestions are appreciate. TIA Bill -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php--- End Message ---
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
