Hi

Just following through this thread and I agree it is a programming error
causing a waste of resources. But I am confused as to why this is a
problem for Firebird. I thought that lots of short transactions was
actually something to be encouraged over long running transactions. Is
there some limit to # of transactions / time period?

Clearly I need the transaction training video mentioned by Thomas :)

Cheers
Rob