Subject Re: [firebird-support] Data of multiple years and opening stocks & balances
Author Venus Software Operations
On 03/03/2011 05:53, Thomas Clarke wrote:
> > Bhavbhuti,
> I have used both methods:
> 1. Store the balances via a year end procedure.
> 2. Compute them as needed.
> I think it depends on the volume of data in the database. For a small
> database I would be tempted to compute opening balances and for a large
> database I would store them at year end or whenever required.
> Thomas Clarke
> Cyber Sea Incorporated
> web:

Thanks Thomas for your views. I am torn between, I do not want to store
calculated values, yet I need to deliver efficient reporting.

Kind regards