Re: Subquery with range uses filesort

[David Marcus]

> What do you mean by "Duration" and "Fetch"?

That is how MySQL Workbench reports query times. See

http://forums.mysql.com/read.php?152,560430,560610#msg-560610

> Switching to InnoDB may help performance right away!

I wrote the first version of the website in 2004. MyISAM was the
default at the time and seemed a reasonable choice.

I suppose I could switch to InnoDB. While I haven't looked into it
carefully, my impression is that things should be done differently for
InnoDB, e.g., not locking tables.

I could experiment with changing the MyISAM index and InnoDB on my
development PC.