Pack/Reindex

At times you may need to rebuild the database indexes to insure optimal performance.  VFP users will also want to regularly remove the records that have been marked for deletion.

To run the Pack/Reindex routine:

1. Confirm that all other users are logged out of Student Manager.
2. Select Tools > Database Admin > Pack/Reindex.

VFP Users

3. You'll be asked if you have made a back up recently. If you have a backup, click the Yes button to continue.
4. The Pack/Reindex window now opens.

5. While you may choose individual databases to reindex/pack, most of the time you’ll want to check Select All Files.
6. If you want to remove all the records that have been marked for deletion, check Pack.
7. Click the Run button to start the reindexing process.

SQL Users

Note: records are automatically deleted in an SQL database, so you will only use this tool to reindex the SQL tables.

3. The Mark Indexes to reindex window opens. The Fragmentation column shows how much fragmentation is in each table. It is strongly recommended that you reindex if there is more 5% fragmentation.

4. Click the Done button to reindex the SQL tables.

The length of time it takes to reindex/pack depends upon the number of records in your database, the network speed, and the speed of your machine.