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.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

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