> We've got a site makes several queries to our MySql db in every site page. > Should we be using persistent connections, or are we better off opening > and > closing connections on each query?
You should open a connection at the beginning of your page, run your multiple queries, and then close it at the end. You shouldn't be opening a connection for each query. As for persistent vs. normal, here's a good explanation of each option: http://www.php.net/manual/en/features.persistent-connections.php ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
