Well, obviously I would try creating compound indexes. So one index
would be created, author and the other would be author, created. But it
seems like you tried that.
You say you adjusted the max_seeks_for_key, but have you adjusted the
sort_buffer? Sorting does seem to be your bottleneck and t
Hopefully someone can help me out here :)
I have a pretty simple table that is 400k rows and growing. I'm doing,
to me, some relatively simple searches but they are taking forever (6
seconds in my case is faaar too long). Anyway, here's the setup:
Tested on MySQL 4.0.21 (Windows 2000 Server
