index rebuilds

[Richard Kreiss]

This just confirms what I thought. 

Richard
Sent from my iPhone

> On Sep 23, 2020, at 3:06 PM, laura.k.brody via Filepro-list <filepro-list at lists.celestial.com> wrote:
> 
> 
> No, no processing runs during an index build. Only *report and *clerk execute processing. Laura Brody Sent from my Samsung Galaxy smartphone.
> -------- Original message --------From: "Jay R. Ashworth via Filepro-list" <filepro-list at lists.celestial.com> Date: 9/23/20  2:52 PM  (GMT-05:00) To: Filepro 2 List <filepro-list at lists.celestial.com> Subject: Re: index rebuilds ----- 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 dxmaintin any type of rebuild, no.  It seems to me that I once wanted to do that, and wastold I needed to add a new column, stripe it, and then index on that.  Probablysomething 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.comDesigner                     The Things I Think                       RFC 2100Ashworth & Associates       http://www.bcp38.info          2000 Land Rover DIISt Petersburg FL USA      BCP38: Ask For It By Name!           +1 727 647 1274_______________________________________________Filepro-list mailing listFilepro-list at lists.celestial.comSubscribe/Unsubscribe/Subscription Changeshttp://mailman.celestial.com/mailman/listinfo/filepro-list
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20200923/af3bc81c/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list