10 - 20 GB with 50 users with reasonably written code causes FB no problems
what so ever. With a bit of careful coding the users can go well past 100
users.

The main pitfalls are not thinking about the impact on the server when
writing code, by repeating huge queries over and over again etc.

JAC.

<zifnabbe@...> wrote in message
news:b2g8ig+k6qj@......

> > How big?
>
> At the moment just some 20-30 MB, but I'm sure it will eventually
> rise to GB's, since normally nothing will be deleted from the tables.
> I just want to be informed well, so that I can help quickly (or make
> some prevention) of what can happen with big databases.
>
> > How many users?
>
> Oh, not that much... Just 3-4 users.
>
> > What access mechanism?
>
> What do you mean by this? I connect to the database with IBOObjects
> (in Delphi), but I will probably switch to dbExpress. The connection
> itself is through TCP/IP
>
> Thanks.
>
> > JAC
> >
> > <zifnabbe@u...> wrote in message
> > news:b2dvrj+i04v@e...
> > > Hi,
> > >
> > > I started to use Firebird for an application. Normally this
> > > application would have been temporary, but it looks like the users
> > > want to use it for a long time now.
> > >
> > > A lot of data will be stored in the database (I know Firebird
> will be
> > > able to handle this) and I'm wondering if there exist some
> guidelines
> > > on large firebird databases. On what do I've to look, how to
> handle
> > > so things will work flowlessly. Which checks have to be done
> > > regulary, what are the limits, how to overcome these limits, etc.
> > >
> > > Thanks in advance!
> > >
> > >
> > > 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/
>
>
>