D. Re-indexing your system. Why should you do it and how does it work?
Many of you may know the benefits of re-indexing your system as part of the maintenance of your system. Indeed, sometimes it is necessary to run the re-indexing utility to fix ‘corruption’ errors that can occur if your system has been cut off in mid flow by a network error, power failure, or other abnormal stoppage!
Your system has two primary types of file for storing and accessing your data. The first is the database table that has a filename that ends in DBF. The DBF file actually holds all of your data in ‘records’. For example, the main job file is called CUSTORDS.DBF and this holds one record per job. In order for your system to retrieve this data efficiently, we use index files, which normally have the extension .NTX to hold different sort sequences that holds a look-up table of the ‘key field’ and a record number. E.g. A simple index would be on the ‘key field’ of the Job Number, so the look up table could be simply:
Job Number | Record No
10030            50
10031            51
So when you enquire by job number, your system looks up the record number in the index and goes straight to it, otherwise it would have to trawl through each record until it found the matching job number and this would obviously take longer and longer the more jobs you have! As this index sequence is updated every time you add a job to the system, by any machine on the network, if there is an error during the adding of a job, then this index would have a good chance of being corrupted by either having no entry for the Job added or an incomplete one. Your system has some 250+ databases and some 450+ indices. So it is worth re-indexing them occasionally to ensure they are optimised.
Finding Your Indexing Utility
To re-index your system you need to find the indexing utility in the main program directory and look for a .EXE file that has the letters ‘IDX’ in it e.g. EMIRIDX.EXE. Simply click this file to re-index, but call us first if you are unsure – and you must make sure that no-one is using the system at the time, and also be aware that it could take some time depending on the size of your data. So, maybe running it at the end of the day when everyone has finished using your system is the best time. If you get a ‘Corruption’ message then this is normally the way to fix it.
Back to top