3 ms·
> When it does become a problem it can be solved by caching. Solved or made worse by caching?
by mtanski 10y ago
> When it does become a problem it can be solved by caching.
Solved or made worse by caching?
- dsp1234 10y agomade worse by caching Caching may relieve some stress (on say a dashboard), but if an application is doing calculations around account balances, and uses event sourcing-like structures in the database, then caching isn't going to help as those calculations are going to still need to be done for each new balance changing event. So caching is never worse (unless you accidentally used the cached value where you needed the live value), but isn't necessarily going to relieve a lot of DB stress.
- cookiecaper 10y agoSince it's append-only, can't you "cache" or snapshot the calculation in pieces? e.g., "Today @ 00:00 all events on this account summed up to 100." Then you just replay today's events. You don't have to recalculate anything unless you're changing your transformations. Make your checkpoints whatever interval is necessary to make on-demand event replay acceptably performant.