By: Borland Staff
Abstract: The use of a database defined sweep interval really depends on what yourapplication does and what type of maintenance you want to employ on yourBR>database.
I dont know when or why I should or shouldnt use sweep intervals
The use of a database defined sweep interval really depends on what your
application does and what type of maintenance you want to employ on your
As a general rule, use what works best for your database needs.
If your application uses very quick transactions you may not need to use it.
If your application has both long and short running transactions you most
likely will want to employ some type of db sweeping.
Choosing a sweep interval is totally application and performance dependent.
If you disable the sweep interval, make sure that you either manually
sweep the db periodically or as needed (when performance is suffering)
or run scheduled gbak and restores without the -g switch used.
Trial Download Week!
Click here to download a free 30-day trial of InterBase XE3 Server or ToGo editions. Or download a free non-expiring Developer Edition >
More InterBase Info
InterBase XE3 Product Info
Free Developer Edition download
InterBase on Google+
Follow @InterBase_ on Twitter
Server Response from: ETNASC03