Subject Re: [firebird-support] Re: Next TX #, OAT and Connection Duration?
Author Tim Ledgerwood
> > 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
> > operations.

Well, IMHO, that's the first thing I would change. In my experience, it's a
LOT of work to put in explicit transaction control, but it pays off BIG
TIME, for precisely these sorts of reasons. And the same comment is true of
any client - server database.

I wouldn't trust the BDE to don anything at all ...

Regards

Tim


[Non-text portions of this message have been removed]