Re: mysql persistent connections / php4

MYSQL_SELECT_DB is neither smart nor persistant. If your code calls SELECT_DB, mysql executes it. I actually use persistant connections on a server handling ~40 mysql enabled clients. It increases my performance to have all of my MySQL connections cached, so all each customer query needs is a change db, make query. -brendan ----- Brendan W. McAdams | ph. (305)377-2880 email: brendan@plexmedia.com | cell: (305)218-6466 Programmer/Systems Administrator | pager: (305)277-4879 Plexus M/2, Inc. | fax: (305)377-2870 http://www.plexmedia.com "Always listen to the experts; they'll tell you what can't be done and why. Then do it." - Robert A. Heinlein ----- Original Message ----- From: "Patrik Wallstrom" <pawal@blipp.com> To: <php-general@lists.php.net> Sent: Friday, August 11, 2000 9:37 AM Subject: [PHP] mysql persistent connections / php4 Hi, I am curious over these lines in my mysqld.log: 355 Query SELECT Value FROM Session WHERE SessionID = 'f302e1a31ccf0bcdb75547bb0ea9f83b' AND Expires > NOW() 355 Statistics 355 Init DB sonoxsession 355 Query SELECT SessionID FROM Session WHERE SessionID = 'f302e1a31ccf0bcdb75547bb0ea9f83b' 355 Statistics 355 Init DB sonoxsession Why Init DB and Statistics, when I use pconnect? -- patrik wallstrom | f o o d f i g h t tel: +46-8-6188428 | s t o c k h o l m gsm: +46-708405080 | - - - - - - - - - fax: +46-859827151 | -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net