freechn

[Richard Kreiss]

Richard
Sent from my iPhone

> On Mar 3, 2015, at 10:16 AM, Kenneth Brody <kenbrody at spamcop.net> wrote:
> 
> On 3/2/2015 7:20 PM, Richard Kreiss wrote:
> [...]
>>>> Is there a way to use a wildcard to have freechn rebuild the primary
>>>> file as well as all of the qualifiers?
>>> 
>>> You can't put a wildcard on the command line, but you can put it in a
>>> loop.
>>>   What O/S are you on?
>> 
>> Windows
>> 
>> I think it might be easier to just copy the command line and add each
>> qualifier  (4).
>> 
>> Of course one of the qualifiers has almost 20 million records at this point
>> and it grows at 1,000 records a week.  This is an indexed file.
>> 
>> The freechn needs to be run on the server otherwise it take much too long to
>> finish.
> 
> I guess the bigger question here is...
> 
> Why do you need to rebuild the freechain on a regular basis?
> 
> -- 
> Kenneth Brody

Proactive. When this happens, and it does, one of the clerks gets the message on her computer and this stops everyone. Rebuild on the server takes far less time. 

This company deletes order details that are not shipped. The details are in both the order file and order history files. Old shipped orders are periodically purged from the order file but not history. 

There is another file which I don't go near as it has data from day 1 of when FilePro was activated over 20 years ago. This file passed the 2gb size just as 5.6 became available. 

I need to get them to upgrade to 5.8 as there have been many bug fixes since their last upgrade. 

Richard