Subject Re: Re: [firebird-support] Re: Performance when deleting a lot of records, again
Author Pavel Menshchikov
Hello Martijn,

MT> Actually, not Delphi... But I guess you mean "IBX". I don't think IBO
MT> does a CommitRetaining unless you tell it to. How about FIB+?
AFAIK, the recommended practice for FIB+ for an updatable data set is
to use two transactions with the data set: a long read-only
transaction (read committed) and a short writing transaction
(concurrency, no wait). The data set has Transaction and
UpdateTransaction properties for that.

Best regards,
Pavel Menshchikov