Environment variables for Building indexes

[Nancy Palmquist]

Recently I asked if anyone had suggestions on how to set the environment 
variables so indexes would build faster and the responses were to play 
with different combinations.

So here is the result:

Running on Windows, I discovered these worked very well.

PFBIXBUILD=1
PFNUMIXBUILD=4096  (Linux I used 16448)
PFNUMIXBUF=200
PFBIXNODESIZE=24

PFBIXBUILD was set at 2 because the manual indicated for large files 1 
might work better.  (I have files bigger than 2Gig so I thought 1 was right.

PFBIXNODESIZE values 1-31 are allowed.
PFNUMIXBUILD can be 10 to 128000.  I tried large numbers but this was 
some kind of memory allocation and it crashed if the number was too high.
PFNUMIXBUF can be 1- 200

So maybe this help someone else that does not have time mess with it.

BTW on Windows- the job that built the indexes went from running for 6-7 
hours to 3-4 hours.  A huge difference.
On Linux the job went from 3 hours to less than 1 hour.

Nancy

-- 
Nancy Palmquist
Owner
Virtual Software Systems - www.vss3.com
(412) 835-9417

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20181115/7602e3cf/attachment.html>