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
