Re: Database library recommended

On Thu, Mar 19, 2015 at 8:06 AM, Matthew Lagoe <matthew.lagoe@subrigo.net> 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@gmail.com] > Sent: Wednesday, March 18, 2015 05:00 PM > To: Robert Williams > Cc: PHP List > Subject: Re: [PHP] Database library recommended > > On Thu, Mar 19, 2015 at 7:24 AM, Robert Williams <rewilliams@thesba.com> > wrote: > > > > > > On Mar 18, 2015, at 08:27, R B <rbpphp@gmail.com> 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>