Subject RE: [firebird-support] Re: Performance when deleting a lot of records, again
Author Gili Buzaglo
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.
Its a very critical bug in my server.

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

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