Index Rebuilding Speed on 5.1 Windows Server 2008

[Nancy Palmquist]

Friends,

I am trying to speed up some index building and I all looking at the 
environment to see if I can make any changes that might help.

These run directly on a server (Windows Server 2008) to eliminate 
network slowdowns, with no competition for CPU time except for what 
Windows does itself in the background.

The files are larger than 4,000,000 records and live on P:.
Current settings for variables that might affect speed to my thinking.
PFTMP=P:\tmpC
PFBIXBUILD=2    (suggestion is that 2 is for large files, and we have 
been using this as the default)
PFBIXNODESIZE=1
PFNUMIXBUF=200
PFNUMIXBUILD=200  my notes say this can be as much as 204800, might that 
help?
Please feel free to submit any others that I am overlooking if you have 
suggestions.  Also if there is some Windows adjustment we can make if 
you have found one.  We have to rebuild 16 indexes and it is taking 6 
hours to do it sequentially.  That is 3 in one file and 13 in another.  
I am afraid running them simultaneously will not improve speed but I can 
try that to make sure.  Unlike Unix/Linux I have found Windows to be 
unable to handle simultaneous jobs without decreasing the effectiveness 
of both.

I expect with newer OS and hardware maybe these values can be tuned to a 
better place.  We are trying to transition to 5.8 but we have to keep 
the current system working to have time to get the stuff in place for 
that change.

Any suggestions will be kindly accepted and I thank you for your help.  
It is very hard to experiment when it takes so long to run these and is 
environmentally affected.

Nancy





-- 
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/20181015/eea7fb07/attachment.html>