If my understanding is correct then the sweep interval if set to let's say 20,000 would then wait for a gap of this amount between the oldest transaction and the oldest active transaction, once this gap is reached between these two counters then it would fire a sweep.

If you set a sweep to 0 it will never fire a sweep, you will always have to manually fire one off.

I think the only way you are going to get the transactions in line is a backup and restore, but more importantly you need to find out where your transaction is being held open, as this is what is causing your gap.

I hope I have informed you correctly, if not I am sure someone will correct this reply.

Martin Dew


-----Original Message-----
From: xuxu [mailto:xufh@...]
Sent: 22 December 2004 09:29
To: firebird-support@yahoogroups.com
Subject: [firebird-support] fb statistic


firebird-suppor

The usage of cpu of my FB always grows up to 99% . Here is the statistic of my FB .I have set the sweep interval
to 0 .but the difference between the next transaction and the oldest active transaction is very large.

Database header page information:
Flags 0
Checksum 12345
Generation 1662925
Page size 4096
ODS version 10.1
Oldest transaction 1636503
Oldest active 1636504
Oldest snapshot 1615008
Next transaction 1662909
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jun 4, 2004 9:44:42
Attributes

Variable header data:
Sweep interval: 0
*END*




　　　　　　　　xuxu
　　　　　　　　xufh@...
　　　　　　　　　　2004-12-22




------------------------ Yahoo! Groups Sponsor --------------------~-->
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/67folB/TM
--------------------------------------------------------------------~->


Yahoo! Groups Links