Thanks Rick for your reply and providing details.

Kind regards.
Bhavbhuti

--- In firebird-support@yahoogroups.com, "Rick Debay" <rdebay@...> wrote:
>
> Point-of-sale transactions, inventory transactions due to POS activity,
> and summarized versions of both that are then pushed to the accounting
> system based on invoice cycles. Really simple stuff.
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of venussoftop
> Sent: Friday, August 21, 2009 1:19 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: Desgin question - Mutiple years of data,
> single database or many?
>
> Thanks Rick, this has improved my confidence of keeping the data
> together. From what you have written it seams you have some kind of
> accounting and / inventory application, maybe an ERP?
>
> Thanks for replying
>
> Kind regards.
> Bhavbhuti
>
> --- In firebird-support@yahoogroups.com, "Rick Debay" <rdebay@>
> wrote:
> >
> > We keep everything, and make sure to have appropriate indexes on date
> > fields. The only problem we ever have is when we fail to include a
> > constrain the date range on large calculations.
> > We archive data only when it is older than various data retention
> > mandates, usually five or seven years. Then it rots on a tape in a
> > safety deposit box.
>
> Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference.
>