Andy_Langton - 8:53 am on May 16, 2012 (gmt 0)

I tried adding an index to first my_item then item_category, but that actually seems to be slower!?

20.9625 sec

Perhaps I just have too big a database for this server to handle quickly - I just want to make sure I'm not doing something basic incorrectly. Still, could be a pretty hefty hardware upgrade to take it down from 20 seconds to something more palatable.