> Iam reading your comment here and as usual Iam learning a lot from it.
> May I ask a few question? In my application I always doing a hard commit
> (ib_transaction.commitretainning;) every time a record has been post or
> update to make sure that all the other client are viewing the lastest
> and updated records. Will there be any bad effect to the Firebird
> performance if I always making a hard commit?
>
> Thanks in advance to your comment. :-)
>
> James

If you always and only do a CommitRetaining, you will always be retaining
the transaction context. You should (must) more often do a Commit and move
the transaction along. I most always Commit and keep CommitRetaining to a
miminum.

Alan