2 ms·
> They use running totals with audit trails, which is exactly what temporal tables provide. In the author's case, they separate writes and reads into different
by ricardobeat 1y ago
> They use running totals with audit trails, which is exactly what temporal tables provide.
In the author's case, they separate writes and reads into different DBs. The read-optimized DB has aggregated balances stored, not events. This is not materially different, and the trade-offs regarding staleness of data will be mostly the same.