3 ms·
When storing financial data, I'd certainly go with some kind of event sourcing: store deltas / financial transactions, not counters. The counters are just a sum
by perlgeek 12y ago
When storing financial data, I'd certainly go with some kind of event sourcing: store deltas / financial transactions, not counters. The counters are just a sum over all deltas.
If performance is an issue, you can make the counters available in a second database that's only for reading, and updated from the original deltas.
- obstinate 12y agoIt seems from this article that Aerospike can lose acknowledged writes, so that would not be enough to save them.