<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from text --><style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<div>
<div>
<div>From preliminary testing moving from 15k Sas to SSD is at least 10 times faster.
</div>
<div><br>
</div>
<div><font style="color:#333333"><i>Sent from my Verizon 4G LTE Droid</i></font></div>
</div>
<div class="x_elided-text">On Oct 29, 2017 2:14 PM, Richard Kreiss via Filepro-list <filepro-list@lists.celestial.com> wrote:<br type="attribution">
</div>
</div>
<font size="2"><span style="font-size:10pt;">
<div class="PlainText">On a Windows based system, is there a way to have filePro check if dxmaint is rebuilding indexes on that file?<br>
<br>
Situation:<br>
<br>
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.<br>
<br>
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.<br>
<br>
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.<br>
<br>
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.<br>
<br>
Any suggestions?<br>
<br>
<br>
Richard Kreiss<br>
GCC Consulting<br>
<br>
<br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: winmail.dat<br>
Type: application/ms-tnef<br>
Size: 15184 bytes<br>
Desc: not available<br>
URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20171029/dc5cfa28/attachment.bin">http://mailman.celestial.com/pipermail/filepro-list/attachments/20171029/dc5cfa28/attachment.bin</a>><br>
_______________________________________________<br>
Filepro-list mailing list<br>
Filepro-list@lists.celestial.com<br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</div>
</span></font>
</body>
</html>