Subject RE: [firebird-support] Re: Performance when deleting a lot of records, again
Author Gili Buzaglo
I was seek last week so that why I'm answering so late.

It seems that closing all connections does not resolve the database state.
Here is the output after I've performed
pkill -9 fb_inet_server
(to close all connections)

gstat -h:

Database header page information:
Flags 0
Checksum 12345
Generation 179637
Page size 4096
ODS version 10.1
Oldest transaction 1677
Oldest active 1678
Oldest snapshot 1678
Next transaction 179629
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 3
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Apr 10, 2005 17:19:37
Attributes force write

Variable header data:
Sweep interval: 0


-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: Thursday, April 07, 2005 7:52 PM
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.




Yahoo! Groups Links

* To visit your group on the web, go to:

* To unsubscribe from this group, send an email to: <>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <> .

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