Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> performance question: sum values vs. store calculations
The legacy banking system that we are rewriting stores the results of
calculations in tables. For instance, when a balance is calculated
account for a new transaction, the new balance is stored on the
the account.
to store only
(and other calculations) when requested.
decision is a performance hit, but
calculation will involve about 50-100 records from a total of 1.5
records. This will be a 24x7 system that expects sub-second
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Mon Aug 30 1999 - 23:14:03 CDT