Dxmaint

[Richard Kreiss]

On a Windows based system, is there a way to have filePro check if dxmaint is rebuilding indexes on that file?

Situation:

The is a service that rebuilds all of the auto indexes for their order header & order detail files.  This service starts at 4 AM on Sunday and take a long time to run as there are 10 order header indexes and 12 order detail indexes.  Both files have a qualifier and these indexes are also rebuilt.

The primary order header file has 1, 075,176 records and the order detail file has 22.719,170 records.  Most of these indexes are multi key.  The header file rebuilds fairly quickly.  It is the detail file that takes a lot of time.

The problem occurs on a Sunday when someone tries to access the orders during the rebuild.  The header file auto processing does some lookups to the detail file to display information about the details before the first screen is displayed.  When the rebuild is happening it appears that the header file access is hung-up when actually the program is just waiting for the indexes to be available.

I would like to be able to avoid the lookup to the order detail file when they are being rebuilt and put up a message that the index rebuild is occurring and access will be available when the rebuild is completed.

Any suggestions?


Richard Kreiss
GCC Consulting


-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 15184 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20171029/dc5cfa28/attachment.bin>