Hi Anderson

Thanks for your continued responses. Reading your detailed reply and the facts presented I think I should be fine with multiple years, of course the client will have to confirm that this is fine with him. I have been thinking that I can limits the data coming down the wire by either VFP remote views and / or FB views as I have a settings table in the database that will contain the current year the user is viewing / editing. Plus like mentioned in Rick's email indices which are on the transaction date fields might also help me with this.

Thanks and regards.
Bhavbhuti

--- In firebird-support@yahoogroups.com, "Anderson Farias" <peixedragao@...> wrote:
>
> Hi,
>
>
> >What I have missed to mention is that I had an Accounting and Inventory
> >system in mind when I wrote this question.
> >If I may ask, is your application similar?
>
> Not really. But I've worked for a company that has one.
>
>
> > How big is the database? How many years do you currently have in it?
>
> The Accounting/Inventory/Sales software I've worked does not have a big
> database. The bigest customer I know has about 4 years of data but
> Accounting has take place only about 2 years (AFAIK). The database is a
> little more then 5.2Gb
>
> Accounting records has about 58k entries/month (1.2milion rows today)
>
> The database keeps a sumary (balance) for each account/month (using
> Triggers) AFAIR. This helps getting faster responses on reports at any given
> period of time. I rememver we had to rise locking settings on Firebird.conf
> for this to work nicelly. This database has more than 150 concurrent
> connections on Firebird 1.5 CS.
>
>
> >One typical problem that I have faced and will face is for eg. receivables
> >outstanding.
> > Wherein invoice data of the previous year needs to be maintained long
> > after end-of-year processing
> > has been run for bill-to-bill adjustments.
>
> I don't know how many records you have for each year, but I *think* you
> could easily have at least 2 years (current one and last one) on your
> current 'working' db;
>
>
> Regards,
> Anderson
>