Subject RE: [firebird-support] Re: Performance when deleting a lot of records, again
Author Gili Buzaglo
Hi again
I forgot that we also have clients that access the datbase through SQLApi,(its a c++ program running on solaris
that use the SQLApi)
Do you know any bugs regarding it ?
-gili

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


Gili Buzaglo wrote:
> What is a culprit ?
> Anywhay, even if I close the ibconsole, there is still a gap!

The culprit is the guilty person. IBConsole starts a snapshot
transaction when you use it to query the database. That transaction
stays open until explicitly closed.

Try closing all connections to the database, then run gstat -h and send
us the results.


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]