0
votes
1answer
123 views

Which is faster, key_cache or OS cache?

In a tb with 1 mil. rows if I do (after I restart the computer - so nothing it's cached): 1. SELECT price,city,state FROM tb1 WHERE zipId=13458; the result is 23rows in 0.270s after I run 'LOAD ...