index rebuilds

[Jay R. Ashworth]

----- 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.

-- 
Jay R. Ashworth                  Baylink                       jra at baylink.com
Designer                     The Things I Think                       RFC 2100
Ashworth & Associates       http://www.bcp38.info          2000 Land Rover DII
St Petersburg FL USA      BCP38: Ask For It By Name!           +1 727 647 1274