Hi,

Your reply seems interesting. In our case each organisations
data
can be kept seperatly and there is no need for cross analysis.

Thank you very much.

Ben.


On Mon, 04 Mar 2002 Jason Chapman (JAC2) wrote :

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