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.