Subject Re: [ib-support] Re: Firebird slows after some Hours with 40+ Users
Author Phil Shrimpton
On Tuesday 10 December 2002 09:13, you wrote:

Hi,

> > > Oldest snapshot 16210
> > > Next transaction 34332
> >
> > Here you have it - quite a large difference...
> >
> > You need to keep your transactions short - as short as possible.
> >
> we┬┤ve got an dbgrid connected to the database which is open all the time.

Oh dear. This is your problem You need to change this so that you start a
transaction, populate the grid, and then commit. Depending on what you want
to do with the data in the 'grid', you might want to look at using a
ClientDataSet or your favorite third-party alternative to cache the data
client-side.

Phil

--
Linux 2.4.4-4GB
8:47am up 6 days, 15:14, 1 user, load average: 0.27, 0.19, 0.12