Is anyone switching from MySQL?
dgerard at gmail.com
Thu May 21 13:16:43 BST 2009
2009/5/20 Scott <sclewin at sgaming.ca>:
> On May 1, 2009 09:58:21 am Samuel Thurston, III wrote:
>> I seriously recommend looking into ADODB for php.
>> http://adodb.sourceforge.net/ It not only greatly simplifies the
>> process of writing database code, but it also makes your app more
>> less database agnostic. If more people used an abstraction layer,
>> potential sea-changes wouldn't be such a big deal. The other nice
>> thing is that it leaves the option of what database backend to use
>> the end-user, and aren't we all about free choice around here?
> I am sorry about the late reply, but I thought I would just mention I am
> going to take your advice and try ADODB. Thanks for the suggestion.
Note that there is, as one would expect with a little thought, a
performance penalty over writing DB-specific queries, and this can
affect large sites - there was discussion of ADODB on the wikitech-l
list (Wikimedia technical discussion) and someone there put using
ADODB instead of hideously overoptimised and tweaked MySQL at ~14-15%,
IIRC. The MediaWiki solution is its own app-specific DB access class
which translates the queries you'll need into DB-tweaked code for each
More information about the sounder