Subject RE: [firebird-support] Re: Performance when deleting a lot of records, again
Author Gili Buzaglo
Hi, remember me
Well after a lot of investigations, I managed to keep the next transaction number close to
the old snapshot number (at the gstat -h output).
I had a client running on solaris, written in c++ and using SQLAPI to connect to the database.
The client only read from the database.
It seems the only when I close the connections every X queries, those numbers did not got so far.
But the database is still growing, I had a database of 70 Megas ,and after backup and restore it is 6M !.
when the database is this big some operations become very slow and it is impossible for the
server to perform under those conditions.
The output of gstat -h in this state was:

Database header page information:
Flags 0
Checksum 12345
Generation 3035282
Page size 4096
ODS version 10.1
Oldest transaction 3034574
Oldest active 3034575
Oldest snapshot 3034288
Next transaction 3035273
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 20, 2005 19:19:56
Attributes force write

Variable header data:
Sweep interval: 0

I also perform sweeps manually about every 12 hours when the load is minimum.

Do you have any ideas how should I proceed ?

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