Subject Re: Firebird slows after some Hours with 40+ Users
Author dimi1309 <ich@dimi.mdis.de>
--- In ib-support@yahoogroups.com, "Martijn Tonies" <m.tonies@u...> wrote:
> Hi,
>
> > Oldest transaction 16209
> > Oldest active 16210
> > 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.
>
> Mind you, also a SELECT uses a transaction. While editting, post
> all your changes in a transaction and call COMMIT (not retaining)
> afterwards.

we┬┤ve got an dbgrid connected to the database which is open all the time. a=
re there db-components, able to commit the transaction transparently and ope=
n it, when needed ?