Combing PDO with mysql_pconnect connections in one application --will this degrade performance?
in [Databases]
|
Prev: Multiple MySQL schemas
Next: Combing PDO with mysql_pconnect connections in one application-- will this degrade performance?
From: Sara Leavitt on 9 Dec 2009 14:11 Hi, We are about to convert all of our queries using mysql_pconnect to prepared statements using PDO database connections. It will take some time to convert the hundreds of SQL statements so the plan is to do it in phases. Is it a bad idea to have both a mysql_pconnect and a PDO connection open for the same application? Will this doubling of our database connections for every page hit degrade performance? Any tips on the best way to transition to PDO/prepared statements with minimal disruption? -Sara |