News for hackers. Stuff that matters.
Re:Re: MemSQL the “world's fastest database”? (2012) by colanderman on Thursday October 02, 2014 @12:10AM (#8399386)
So it's not a disk vs. memory thing, it's a B-tree vs. skiplist thing. That makes a lot more sense.
Re:Re: MemSQL the “world's fastest database”? (2012) by latch on Thursday October 02, 2014 @12:20AM (#8399410)
I'm pretty sure the two are related, no? A B-trees is a disk-friendly structure (shallow and wide), skiplist aren't (but they are a concurrency friendly structure)
Re:Re: MemSQL the “world's fastest database”? (2012) by colanderman on Thursday October 02, 2014 @10:43AM (#8400909)
Right. My point is that "you can't use atomic instructions with disk-backed databases" is oversimplified to the point of being incorrect: it's wholly feasible for, say, Postgres to implement a skiplist-based index (or some other lock-free data structure) while still backing its store with the disk, with the only downside being a performance hit if working memory is not large enough.