Subject | RE: [firebird-support] Re: Performance when deleting a lot of records, again |
---|---|
Author | Gili Buzaglo |
Post date | 2005-04-17T14:54:10Z |
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:
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]
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 ?The culprit is the guilty person. IBConsole starts a snapshot
> Anywhay, even if I close the ibconsole, there is still a gap!
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]