Disabling Automatic Sweeping
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.