Hi, all.
I'm creating a basic budgeting/forecasting application and I'd like some possible solutions to this issue: Rather than have the app go through all the debits and credits to calculate the current balance each time the app is used, I'd like to have the previous balance already available from the last time the app was used. Would the best way be to store the previously calculated current balance in a database table with the date of the calculation, so any additional debits and credits are added and subtracted from that balance? Or is there another way to do this so there's not so much calculation everytime the app is run. indexing? Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289504 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4