Hi
I've copied the database from the server and run gstat -h on it.(see bellow the result)
I guess you meant to do this action directly on the orginal database, but I can not do it.
I still do not know what is the problem, and its very hard to reproduce since when I perform a simulation
It is rarely reproduced.
Heeeeelp
Its a very critical bug in my server.
Thanks
-gili

This is the result:

Database "c:\db\garbage.gdb"

Database header page information:
Flags 0
Checksum 12345
Generation 3743231
Page size 4096
ODS version 10.1
Oldest transaction 2632835
Oldest active 2632836
Oldest snapshot 2632836
Next transaction 3743223
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 Mar 30, 2005 17:36:40
Attributes force write

Variable header data:
Sweep interval: 2000
*END*


-----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]