Steven-

If you will look at the roadmap, you will see that the next major release contains MYSQL Query Optimization. Until then, take Linda's advice and add some more indexes and make sure your server can handle the load.