Setting the Sweep Interval Using InterBase Services
From InterBase
Go Up to Setting Database Properties Using InterBase Services
Use the SetSweepInterval
method of the TIBConfigService
component to set the database sweep interval. The sweep interval refers to the number of transactions between database sweeps. To turn off database sweeps, set the sweep interval to 0.
For example, you could set up an application that allows a user to set the sweep interval in an Edit
component:
procedure TDBConfigForm.Button1Click(Sender: TObject);
begin
with IBConfigService1 do
begin
SetSweepInterval(StrtoInt(Edit1.Text));
end;
end;
For more information, refer to “Sweep interval and automated housekeeping” in the Operations Guide.