Subject Re: [firebird-support] Re: Performance when deleting a lot of records, again
Author Ann W. Harrison
Gili Buzaglo wrote:
> Can this be the reason:
> I have the following scenarion:
> 1) A connection is open and I have read query run on it.
> 2) I perform a write query through another connection.
> 3) I commit the write query
> 4)I close the statement of the read query.
> Can it be because step 3 is before step 4 ?

Closing the statement isn't enough. You have to be certain you actually
commit the transaction.