Re: [ib-support] Re: Firebird slows after some Hours with 40+ Users
On Tuesday 10 December 2002 09:13, you wrote:
> > > 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
8:47am up 6 days, 15:14, 1 user, load average: 0.27, 0.19, 0.12