News for hackers. Stuff that matters.
Re:MemSQL (YC W11) Raises $2.1 Million From Ashton Kutcher, ... by gattis on Tuesday July 12, 2011 @02:25PM (#2755822)
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?

Re:MemSQL (YC W11) Raises $2.1 Million From Ashton Kutcher, ... by jganetsk on Tuesday July 12, 2011 @02:27PM (#2755833)
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).
Re:MemSQL (YC W11) Raises $2.1 Million From Ashton Kutcher, ... by nikita on Tuesday July 12, 2011 @03:15PM (#2756068)
This is a correct observation!