SQLite improves performance with memory-mapped I/O

Re:SQLite improves performance with memory-mapped I/O by asperous on Thursday May 23, 2013 @06:47PM (#5760039)

You can use SQL as a document store, you don't have to use joins.

MongoDB queues inserts into memory before flushing it to disk. This means it's not durable in case of a power outage before the data is flushed. Turn on the safety of flushing-first and it's more or less doing the same stuff your sql software is doing.

[ Parent | on HN ]

Re:SQLite improves performance with memory-mapped I/O by lucian1900 on Friday May 24, 2013 @05:17AM (#5761915)

Is is, in fact, much much slower than both SQLite and Postgres. It's even slower than a fully indexed hstore in postgres! (which is pretty much identical to mongo's data model, except consistent, durable, with transactions, etc.)

[ Parent | on HN ]