For forums, blogs and more please visit our
Developer Tools Community.
By: Borland Staff
Abstract: The automation of gfix (sweep) is controlled by the sweep interval setting.
How can we control the time in which a sweep starts.
The automation of gfix (sweep) is controlled by the sweep interval setting.
If you have the setting set to 0, the sweep will never kick off automatically.
If you do this your database can become bloated over time and performance
will suffer. You will need to either manually run sweeps or use gbak and restore
to do it for you.
When using the automated sweep interval, it is triggered by the difference
between the OT (oldest transaction - committed) and the OAT or
OIT (oldest active or interesting transaction - not committed).
When the difference between these two numbers reaches the
"set" sweep interval the automated sweep process is fired off and a sweep
is started. During this time users may feel a performance loss.
Could not retrieve comments. Please try again later.
Free Developer Edition!
Click here to download a free non-expiring Developer Edition or 30-day trial >
More InterBase Info
InterBase XE7 Product Info
Free Developer Edition download
InterBase on Google+
Follow @InterBase on Twitter
Server Response from: ETNASC04