On 27/08/07, Yuri Astrakhan yuriastrakhan@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