Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?

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/