|location||San Francisco, CA|
|visits||member for||1 year, 9 months|
|seen||Jul 3 '12 at 22:27|
|bio||website||juliansimioni.com||visits||member for||1 year, 9 months|
|location||San Francisco, CA||seen||Jul 3 '12 at 22:27|
Can MySQL reasonably perform queries on billions of rows?
You emphasize the huge difference in hard drive vs memory latency but your numbers are off by a factor of 1000. If hard drives have a latency of around 10ms, and memory 10ns, the latencies do not differ by a factor of 1,000 but a factor of 1,000,000!