Ben,

There don't seem to be any replies to this, so here is my 2c worth,

1) We have a system that is used for an administration company (for a number
of companies), we keep their data in separate databases for clarity + th
fact that they can have a copy of the DB's if they wish with no problems.

2) The size of the data shouldn't be a problem, we have a nominal ledger
table with 10 - 20 million rows of data that is live and accessed by 50 -
100 concurrent users.

3) Do you want to do any cross client analysis?

JAC
""Ben Johnson"" <ben_johns@...> wrote in message
news:20020217022150.11687.qmail@......

>
> 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/
> >
> >
>
>
>
>
> 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/
>
>
>