3 ms·
I use MongoDB, collecting just under 200k documents a day for months and I haven't lost any data yet so far that we've found. Sqlite looks pretty speedy though
by bobx11 16y ago
I use MongoDB, collecting just under 200k documents a day for months and I haven't lost any data yet so far that we've found. Sqlite looks pretty speedy though - may try going back to something like that for smaller jobs.
The one thing I found funny is that deleting documents from a database leaves the space allocated and you have to manually run the repair command to reclaim the space, but that requires 100% additional space because it creates a new db and copies the data there.... little bit of a problem since we were already a 99% for the device :-| other than that - been really happy with it.
- kscaldef 16y agoThat's not terribly uncommon. PostgreSQL also does not reclaim space from deleted rows until you vacuum. Many hash table implementations also only mark items deleted rather than actually removing them.
- selenamarie 16y agoAlthough - for further clarification, PostgreSQL doesn't require 2x the total amount of disk to reclaim/reuse space under normal circumstances. As of version 8.1 (out since 2005), VACUUMing is an automatic function inside the server. (autovacuum)
- cheald 16y agoSQLite is really nice for small projects, but it rapidly degrades once it hits large amounts of data. It's wonderfully useful for many things, but managing large datasets is not one of those things.