Database Autopack

The Future Lab database engine Bbuuzzb does not physically delete records when the delete function is called. The record instead is marked for deletion. The records marked for deletion are actually deleted during a pack or sort operation.

Instead of having to manually pack a table, Bbuuzzb has a feature called autopack where each table can have a pack threshold associated with it. Once the number of records in the table exceeds the pack threshold, the table is packed automatically.

The autopack threshold is load into the dbeng_table structure when the table is opened. The autopack threshold is loaded from the catalog if the the table has been cataloged. If the table has not been cataloged, the autopack value is zero (which means that it is inactive for that table).

Goto Top | Future Lab Home | Contact Webmaster | Feedback

Copyright © 2006 Future Lab, Last Updated Jun 30, 2006