Re: Challenging performance demand

[Daniel Nichter]

Here's an idea: Make a composite index on the whole table (every column, starting of course with symbol, etc. as you have it now). Even though the queries are using an index, MySQL still has to hit the hard drive to get the other column values since the queries are SELECT *, and since the current index already covers 4 of 7 total columns, why not just add in the remaining 3? This would allow MySQL to fetch entire rows from the index and avoid the hard drive. Then, you could load the entire index into RAM with LOAD INDEX INTO CACHE. Along with DELAY_KEY_WRITE already, MySQL should handle the table entirely in RAM.