Subject Re: Next TX #, OAT and Connection Duration?
Author hugh_borst

> The secret is to surelly close any active transaction after use it.
> Don't keep any query opened in a non read-only transaction.

What do you mean precisely? Do you CLOSE your connection to the
database after each DB operation has completed? Or, do you COMMIT
each transaction after the work of each is finished?

Our system relies on the BDE to "Auto-commit" each DB operation after
it has completed, so we do not have any explicit Commit calls,
however, we also don't have any open transactions between DB

Closing the connection between operations is, I think, quite costly in
terms of both network traffic and DB resources.

Please clarify.



Hugh J Borst