Setting the Sweep Interval Using InterBase Services

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.