Thanks for all the comments. 2015-03-18 19:06 GMT-06:00 Marcos Almeida Azevedo < marcos.al.azevedo@xxxxxxxxx>: > On Thu, Mar 19, 2015 at 8:06 AM, Matthew Lagoe <matthew.lagoe@xxxxxxxxxxx> > wrote: > > > I have found PDO to only be 1% or so slower on most query's compared to > > mysqli. If 1% performance is going to matter sure use mysqli, or if you > > have very specific features you need that pdo doesn’t offer. > > > > That could be logical. Because what matters is what your query is doing. > E.g. if it is a complex query that takes a few seconds to complete, then > the overhead is very negligible. > > > > > > -----Original Message----- > > From: Marcos Almeida Azevedo [mailto:marcos.al.azevedo@xxxxxxxxx] > > Sent: Wednesday, March 18, 2015 05:00 PM > > To: Robert Williams > > Cc: PHP List > > Subject: Re: Database library recommended > > > > On Thu, Mar 19, 2015 at 7:24 AM, Robert Williams <rewilliams@xxxxxxxxxx> > > wrote: > > > > > > > > > On Mar 18, 2015, at 08:27, R B <rbpphp@xxxxxxxxx> wrote: > > > > > > > > I want to know which is the database library currently recommended? > > > > > > It depends on what you’re building and what database you’re using. If > > > you’re talking about MySQL, PHP offers two supported options: mysqli > > > and PDO. The former is purpose-built for MySQL, while the latter is a > > > cross-database solution that makes it easy to port your code to other > > > database systems. > > > > > > For anything that you expect to really scale up, or where high > > > performance is critical, I strongly suggest using Mysqli. The > > > cross-database nature of PDO means that there’s an extra abstraction > > > layer between your application and the database, and that slows things > > > down. In particular, you can’t properly tune queries to the database, > > > which is important because the database is the slowest part of most > > > applications. You also can’t properly utilize some advanced features > > that are database-specific. > > > > > > > I really recommend PDO. Although there is an overhead, I believe it > > outweighs the benefits. For one, you have the flexibility later to > change > > your mind, should you choose to try another database software. Second is > > PDO really encourages you to write safer code that is not prone to SQL > > injection. > > > > > > > > > > OTOH, if you’re developing a retail application that you expect > > > customers to use with a variety of DBMSes, PDO may be the best way to > > > go, at least initially. Eventually, as you scale up, I still suggest > > > targeting specific databases that you want to support; if done right > > > in terms of code architecture, this need not impact your application > > > code too much — mostly, making some compromises on the data structures > > > to work well with all of the databases rather than being highly > > optimized for one. > > > > > > Regardless, you don’t want to use the mysql API (note missing trailing > > > ‘i’), as it was long ago deprecated and is no longer supported. > > > > > > -- > > > Bob Williams > > > Business Unit Information Officer and > > > Senior Vice President of Software Development Newtek Business Services > > > Corp. > > > (602) 263-0300 x12458 | http://www.thesba.com/ > > > > > > Notice: This communication, including attachments, may contain > > > information that is confidential. It constitutes non-public > > > information intended to be conveyed only to the designated > > > recipient(s). If the reader or recipient of this communication is not > > > the intended recipient, an employee or agent of the intended recipient > > > who is responsible for delivering it to the intended recipient, or if > > > you believe that you have received this communication in error, please > > > notify the sender immediately by return e-mail and promptly delete > > > this e-mail, including attachments without reading or saving them in > > > any manner. The unauthorized use, dissemination, distribution, or > > > reproduction of this e-mail, including attachments, is prohibited and > > > may be unlawful. If you have received this email in error, please > > > notify us immediately by e-mail or telephone and delete the e-mail and > > the attachments (if any). > > > > > > > > > > > -- > > Marcos | I love PHP, Linux, and Java > > <http://javadevnotes.com/java-string-to-long-examples> > > > > > > > > > -- > Marcos | I love PHP, Linux, and Java > <http://javadevnotes.com/java-string-to-long-examples> >
