Facilitating Garbage Collection

From InterBase

Go Up to Database Tuning Tasks


By default, InterBase databases have a built-in function to automatically sweep old record versions when they become too numerous. However, sweeping is partially inhibited by outstanding active transactions. If the server cannot do complete garbage collection, it has to do extra work to maintain each client’s snapshot of the database.

Design your client applications to explicitly start and COMMIT transactions promptly, to reduce the number of outstanding transactions.

See Overview of Sweeping for more details on sweeping, garbage collection, and the database snapshot.

Advance To: