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