Disabling Automatic Sweeping

From InterBase

Go Up to Sweep Interval and Automated Housekeeping

To disable automatic sweeping, set the sweep threshold to zero (0). Disabling automatic sweeping is useful if:

  • Maximum throughput is important. Transactions are never delayed by sweeping.
  • You want to schedule sweeping at specific times. You can manually sweep the database at any time. It is common to schedule sweeps at a time of least activity on the database server, to avoid competing for resources with clients.

To disable automatic sweeping with IBConsole, refer to Setting Database Properties.

Advance To: