Packing

<< Click to Display Table of Contents >>

Navigation:  Concordance > Concordance Administration > Managing Databases >

Packing

Pack the Database

Packing the database regularly can increase database processing and search speed.  It should be part of your normal database maintenance.

Warning

Packing is an exclusive process.  There is no undo function for this process. Records are immediately and permanently removed from the database.  You should export a copy of your deleted records prior to packing.

Note

When packing concatenated databases, you must pack each database individually.

1.On the File menu, select Administration, then Pack, and click Database.  

2.Depending on security, you may be prompted to enter an administrator id and password.

3.The pack process runs and a dialog displays showing progress.

4.Upon completion you can verify the records were deleted by opening the Table view and validate the deleted records are gone.  It is best to also pack the dictionary after packing the database.

Note

If you have an ACCESSID field in your database, you will notice that the accession number does not re-adjust for deleted records. This allows you to view gaps in your database records and verify removal.

Pack the Dictionary

In addition to packing the Database, you should pack the Dictionary to get rid of unnecessary entries.  Good routine maintenance includes packing the dictionary after you pack the database.

1.On the File menu, select Administration, then Pack, and click Dictionary.  

5.Depending on security, you may be prompted to enter an administrator id and password.

6.The pack process runs and a dialog displays showing progress.  When the dictionary has been packed, the dialog closes.