index rebuilds

[Nancy Palmquist]

Richard,

I have a real problem with the -ra flag for index rebuilds.  This is a 
disaster waiting to happen if used as the only way to rebuild indexes.

If an index is accidentally erased or changed, this flag has no clue and 
will not fix those issues.

Erased is easy if some fool hits break during an index build. Poof the 
index is gone.

We had good luck with these variables on Windows Server filepro version 5.0
REM 10 to 200
set PFNUMIXBUF=200
rem option 1 or 2
set PFBIXBUILD=1
rem option 1-31
set PFBIXNODESIZE=24
rem options 10-204800
set PFNUMIXBUILD=4096

Nancy
On 9/23/2020 2:37 PM, Jay R. Ashworth via Filepro-list wrote:
> ----- Original Message -----
>> From: "Richard Kreiss via Filepro-list" <filepro-list at lists.celestial.com>
>> This may be an odd question to ask after over 30 years working with filePro.
>>
>> Does anyone know if Auto processing runs during index rebuilds?
> I have never had any reason to think that automatic processing is run by dxmaint
> in any type of rebuild, no.  It seems to me that I once wanted to do that, and was
> told I needed to add a new column, stripe it, and then index on that.  Probably
> something like Lastname,Firstname.
>   
>> I have a client who is trying to squeeze every last bit of performance out of
>> the SSD drive he just installed.  I am not testing the environmental variables
>> associated with index rebuilds.  FilePro support has not been very helpful on
>> this matter as I don't think they have a good understanding how these variables
>> work.
>>
>> I am testing the following values:
>> @echo off
>> title Rebuld Marketing Indexes
>> SET PFMAXalloc=="256"
>> SET PfMAXTEMP="1500"
>> SET PFNUMIXBUILD=500
>> dxmaint l_patient_market -ra -e
>>
>> By the way he is running Windows Server 2012 and Window 10 clients using SSD
>> drives on the server. He is using external storage connected to his backbone
>> using a 10 GB/S connection. FilePro is 5.8.03.27.
>>
>> As I am not sure if the 4.1 indexes sorting is multi key or if this is a waste
>> as all of there indexes are multikey or have selection sets associated with the
>> auto index.

-- 
Nancy Palmquist         MOS & filePro Training Available
Virtual Software Systems    Web Based Training and Consulting
PHONE: (412) 835-9417           Web site:  http://www.vss3.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20200924/8a00aaf8/attachment.html>