Is anyone switching from MySQL?

David Gerard dgerard at
Thu May 21 13:16:43 BST 2009

2009/5/20 Scott <sclewin at>:
> On May 1, 2009 09:58:21 am Samuel Thurston, III wrote:

>> I seriously recommend looking into ADODB for php.
>>  It not only greatly simplifies the
>> process of writing database code, but it also makes your app more
> or
>> 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
> to
>> 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
supported DB.

- d.

More information about the sounder mailing list