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.
Free Developer Edition!
Click here to download a free non-expiring Developer Edition or 30-day trial >
More InterBase Info
InterBase XE3 Product Info
Free Developer Edition download
InterBase on Google+
Follow @InterBase on Twitter
Server Response from: ETNASC03