[wp-trac] [WordPress Trac] #21663: Use PDO for MySQL queries when PDO is available

[WordPress Trac]

#21663: Use PDO for MySQL queries when PDO is available
--------------------------------------------------+------------------
 Reporter:  scottconnerly                         |       Owner:
     Type:  task (blessed)                        |      Status:  new
 Priority:  normal                                |   Milestone:  3.6
Component:  Database                              |     Version:  3.5
 Severity:  normal                                |  Resolution:
 Keywords:  dev-feedback has-patch needs-testing  |
--------------------------------------------------+------------------

Comment (by brokentone):

 In general I think @deltafactory's suggestions are reasonable, with one
 caveat and one question.

 The legacy connection needs to be able to be turned on and off by a
 constant as soon as it's introduced. I'd prefer off by default, but I
 could go either way so long as it exists. Opening both a PDO and mysql
 connection will double the open mysql connections. While PDO/mysql seem
 negligible in my testing, doubling the connections will be a huge
 performance issue.

 Just think of all the WP sites we've ever seen go down for a DB error, now
 imagine that suddenly happens at half the traffic.

 The question is whether WP has a precedent of version detection. I've seen
 plenty of feature detection and that makes sense, but I don't know if I
 get the value of version detection at an app level in the PHP world.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/21663#comment:67>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software