index rebuilds

[Richard Kreiss]

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

PFBIXBUILD=2



Tells dxmaint to use 4.1 style sorting during build whenever possible. Use this on HUGE files to improve performance - on

smaller files it will actually harm performance. (dxmaint)







-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 13827 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20200922/6f60adef/attachment.bin>