On 02/26/2013 02:14 PM, Luke Welling WMF wrote:
Specifically, do we use MySQL specific syntax that is
more efficient (but
breaks elsewhere) or do we attempt to write lowest common denominator SQL
that will run more places, but not run as efficiently on our primary target?
There's a DB layer for runtime operations (select, update, insert,
etc.), and my understanding is that's supposed to be used for pretty
much everything.
However, part of the optimization is choosing indices, which as you
noted is db-specific (part of tables.sql)
Matt Flaschen