<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body text="#330099" bgcolor="#FFFFFF">
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.<br>
<br>
So here is the result:<br>
<br>
Running on Windows, I discovered these worked very well.<br>
<br>
PFBIXBUILD=1<br>
PFNUMIXBUILD=4096 (Linux I used 16448)<br>
PFNUMIXBUF=200<br>
PFBIXNODESIZE=24<br>
<br>
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.<br>
<br>
PFBIXNODESIZE values 1-31 are allowed.<br>
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.<br>
PFNUMIXBUF can be 1- 200<br>
<br>
So maybe this help someone else that does not have time mess with
it.<br>
<br>
BTW on Windows- the job that built the indexes went from running for
6-7 hours to 3-4 hours. A huge difference.<br>
On Linux the job went from 3 hours to less than 1 hour.<br>
<br>
Nancy<br>
<br>
<pre class="moz-signature" cols="72">--
Nancy Palmquist
Owner
Virtual Software Systems - <a class="moz-txt-link-abbreviated" href="http://www.vss3.com">www.vss3.com</a>
(412) 835-9417</pre>
</body>
</html>