>I've dealt with this issue before in accounting/financial applications. It's also a major concern in OLAP apps and data-warehousing. The simplist way that I have found to address it is to create a summary table of running balances per month, quarter, year. Every single entry updates (or creates and updates) the summary table entry applicable. In my situation, I was trying to avoid doing million-record SUMs for simple P/L reporting.
Well our system isn't likely to run into millions of records, so summing should work for me. :)
-Michelle
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only