Q#21C Other programs reorg.exe

reorg.exe is a program to fix the majority of the errors in a data base which can happen while NPED is running.

Most of the time you are in NPED there is no data base activity.  When you to Add , Change, or delete data there is exposure for the database to become corrupted.  There are 2 pieces to the data base the PED_DB.DB ( actual data ) and PED_DB.IDX the index files which allow the program to run quickly.  The actual physical write to the data portion is done very fast and usually works or does not work. The exposure for damage is only a small portion of a second.   The indexes however have many process and opportunity for damage.  The reason reorg.exe is so successful is that is completely recreates the index portions of the data base.

To show the action of reorg a put the data portion of the data base in a directory by themselves.

reorg program and ped_db

Running reorg.exe shows all of the activity required to build new index files.
reorg running

And the result is the created Ped_db.idx file.

reorg program ped_db & ped_ix


Return to NPED FAQ