Subject Re: [firebird-support] Very fast read only transactions
Author Doug Chamberlin
Jeff Dunlap wrote:
> In a nutshell, can I go ahead and do what I am doing, that is to create a single database, a single transaction, and a single statement and reuse them indefinately? Like I said, I did not experience any adverse effects in my test.

Re-using a connection and a statement is quite common and efficient.
That's what connection pooling is all about.

Re-using a transaction (using one and not committing it for a long time)
is not. This will eventually cause you big problems.

Try changing your test to start a transaction and commit it each time.
Should run quite fast.