Sara Leavitt wrote:
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?
As long as you test it (hopefully using some sort of automated tests) you should be right.
Since you're using persistent connections (make sure you set pdo to do the same), I don't think you're really doubling the number of connections.
Check your mysql logs to see if you are doing double connections or not - that way you'll know for sure.
-- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
