Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> performance question: sum values vs. store calculations

performance question: sum values vs. store calculations

From: <erik_ostermueller_at_my-deja.com>
Date: Tue, 31 Aug 1999 04:14:03 GMT
Message-ID: <7qfkq5$si9$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US