I've been tuning up the SQL and adding further information to the output of EXPLAIN to help in pinpointing a performance bottleneck.
In v2.1 Beta19
open database yourdb
set explain on
SELECT * FROM ....
This provides a lot of useful information about buffers and how to adjust them to optimize your queries.
Bookmarks