Just to clarify-

Im couting the gap as the difference between Oldest Active and the Next Transaction from the Gstat info, have i got this wrong? i do get confused on this issue.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]On Behalf Of Craig Stevens
Sent: Friday, 21 April 2006 12:25 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Gap Value - What is normal behaivour


Hi All,

With the GAP value for the sweep of a database, is there a value or range that this Gap Value can be that is considered normal, as i type this email the calculated GAP is 40000, twice that of the sweep setting, is this normal ??? what should the GAP range be, also what is considered a SHORT transaction? milliseconds - seconds range??

Craig


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links







--
Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.
http://www.mailguard.com.au