Re:Redis and SQLite: Why wait for good enough?
by SkyMarshal on Thursday February 03, 2011 @02:14PM
(#2176261)
Your 'atomic operation' sounds a lot like a transaction. Or am I misunderstanding?
[ Parent
| on HN ]
Re:Redis and SQLite: Why wait for good enough?
by salsakran on Thursday February 03, 2011 @02:36PM
(#2176386)
Not really.
If you have a bunch of counters, you don't want a hot counter to require a transaction every time you want to increment a page view. I'm sure there's a solution in high end DBs, but in mysql/postgres UPDATE somecounter SET value = value + 1 typically ends up being very painful for any significant write load. With Redis and Mongo, there are "atomic" increment operations that do a +X on a given field of a list or hash that is very fast.