Subject Re: [ib-support] Re: Firebird slows after some Hours with 40+ Users
Author Martijn Tonies

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

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
Firebird Workbench - the developer tool for Firebird
Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."