The connection on which the the query run had autocommit=true.
By the way, It seems that if I replace step 3 with 4, the problem does not reoccur!
Opinion ?
-gili

-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: Thursday, April 07, 2005 5:57 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Performance when deleting a lot of records, again


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.

Regards,


Ann



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




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