<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<font face="monospace">Richard,<br>
<br>
I have a real problem with the -ra flag for index rebuilds. This
is a disaster waiting to happen if used as the only way to rebuild
indexes.<br>
<br>
If an index is accidentally erased or changed, this flag has no
clue and will not fix those issues.<br>
<br>
Erased is easy if some fool hits break during an index build.
Poof the index is gone.<br>
<br>
We had good luck with these variables on Windows Server filepro
version 5.0<br>
REM 10 to 200<br>
set PFNUMIXBUF=200<br>
rem option 1 or 2<br>
set PFBIXBUILD=1<br>
rem option 1-31<br>
set PFBIXNODESIZE=24<br>
rem options 10-204800<br>
set PFNUMIXBUILD=4096<br>
<br>
Nancy<br>
</font>
<div class="moz-cite-prefix">On 9/23/2020 2:37 PM, Jay R. Ashworth
via Filepro-list wrote:<br>
</div>
<blockquote type="cite"
cite="mid:267323409.6296.1600886237983.JavaMail.zimbra@baylink.com">
<pre class="moz-quote-pre" wrap="">----- Original Message -----
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">From: "Richard Kreiss via Filepro-list" <a class="moz-txt-link-rfc2396E" href="mailto:filepro-list@lists.celestial.com"><filepro-list@lists.celestial.com></a>
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">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?
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
I have never had any reason to think that automatic processing is run by dxmaint
in any type of rebuild, no. It seems to me that I once wanted to do that, and was
told I needed to add a new column, stripe it, and then index on that. Probably
something like Lastname,Firstname.
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">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.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: <a class="moz-txt-link-freetext" href="http://www.vss3.com">http://www.vss3.com</a>
</pre>
</body>
</html>