Is anyone switching from MySQL?

[David Gerard]

2009/5/21 Scott <sclewin at sgaming.ca>:
> On May 21, 2009 08:16:43 am David Gerard wrote:

>> 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.

> Thank you for the advice.  I have noticed the slowdown when reading
> about abstraction layers and ADODB.  This is one of the reasons why I
> am going to try ADODB because the developers there attempt to
> make a faster abstraction layer.  Also, my page is very low traffic right
> now and I would be pleasantly surprised if it got busy enough for the
> difference in speed to mean something.


Yuh. In practice, if you're not Wikimedia (trying to serve a top-10
website on a vanishingly small nonprofit charity's budget), throwing
15% more hardware at the problem is likely to be a much less
headache-inducing solution. Like using a higher-level language and
letting Moore's Law make up the difference :-)


- d.