On 27/08/07, Yuri Astrakhan <yuriastrakhan(a)gmail.com> wrote:
At Wikimania I spoke with Domas regarding query perf
on real wiki
data. Doing EXPLAIN SELECT on a local db is inaccurate for two
reasons:
* devs tend to run the latest MySQL on their machines, not the 4.xxx
that wiki is using (possibly with additional settings that might
affect performance)
* devs tend to have much smaller sample wiki (I use simple.wiki) to
test, and mysql optimizer might choose a different optimization
strategy.
I'm aware of both of these concerns, however, remembering to do an
EXPLAIN SELECT is, I think, preferable to not doing one at all.
Rob Church