3 ms·

I never heard of a database that doesn't reside in memory if you have enough ram. Most of the time, it's the OS making this happen by maintaining a cache for d

by gattis 15y ago

I never heard of a database that doesn't reside in memory if you have enough ram. Most of the time, it's the OS making this happen by maintaining a cache for disk reads, and flushing writes to disk asynchronously. Does MemSQL just have more compact data structures that let more stuff fit in memory?

jganetsk 15y ago
My guess is if you design your database to reside in RAM, you can use pointers in the data structures. You also can drop all layout optimizations that are meant for linear access (optimize for random access instead).
- nikita 15y ago
  This is a correct observation!