Hi,

Thanks for your valuable reply.

The main 2 tables can grow upto 150,000 for a financial year (March-April).
7 financial years data of each client has to be kept in the database.

Processing activity occurs only at financial year end while generating
reports, otherwise just data entry only. Only 4-5 clients accounts will
be active at a time.

No plan for replication and shadow files.

Considering all this I think I can go for seperate database files for each
client. PLEASE LET ME KNOW YOUR OPINION?

Thank you very much.

Ben


On Sat, 16 Feb 2002 lester@... wrote :

> An easier question to answer.
>
> Do you need to do ANY calculations that involve more
> than
> one customer?
>
> If a lot are needed, then go for one database.
>
> If you only need to bill them <g> then create a database
> with the billing information, and separate databases for
> each client. Then when you select a new client, you just
> change your login for the private stuff. I use
> IBObjects and
> just load a new database path in my case, for each
> station,
> and each of them are on other machines as well!
>
> Backing up all those files can be a problem, but all you
> have to do is set up a gbak command line command and
> populate it from a scan of the billing database. ( We
> only
> restore now ocasionally, but this could be automated as
> well
> )
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
>
> ------------------------ Yahoo! Groups Sponsor
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>