3 ms·
You shouldn't ever even have a "balance" that you update. I was arguing against the grandparent's claim of ACID race conditions; my intention wasn't to advocat
by mootothemax 13y ago
You shouldn't ever even have a "balance" that you update.
I was arguing against the grandparent's claim of ACID race conditions; my intention wasn't to advocate in favour of a "balance" column.
Edit: that said, I wouldn't mind hearing the pros or cons of maintaining a convenience (e.g. page display) "running balance" that is updated from the ledger after every transaction.
- unclebucknasty 13y agoWell, I think the parent was saying that you shouldn't have a balance that is actually relied upon for record-keeping or transactional purposes. If you want to keep one for optimization purposes (i.e. you are reading more than writing and don't want to constantly sum the ledger table), then that's probably outside the scope of the parent's point.