Environment variables for large index rebuilds
Nancy Palmquist
nlp at vss3.com
Fri May 2 09:28:53 PDT 2008
Barry Wiseman wrote:
> This weekend I will be rebuilding all indexes in a large system. These
> folks have long been in the habit of laying time bombs for themselves by
> rebuilding indexes on a non-idle system (don't ask!).
>
> Hundreds of these indexes are large (>10Mb), many dozens are quite large
> (>100Mb, with record sizes ~4K and file sizes ~1M records). They are
> mostly post-4.5, multi-key indexes.
>
> This is a SunOS system, I don't know what the hardware is but it's no
> great speed demon. The customer has scheduled 24 hours of downtime for
> me this weekend, and I'm concerned it may not be enough.
>
> Reading the online manual, I see there are several variables I'm not
> familiar with. As usual, the descriptions shed not much light. Which
> of the following will be my friend on this project? I'm sure the
> tweaking of dxmaint in this manner is very much a black art, but any
> guidelines on useful values will be much appreciated.
>
> PFBIXBUILD
> PFBIXNODESIZE
> PFMAXTEMP
> PFMAXTFIL
> PFNUMIXBUILD
>
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
Barry,
You do not say if they use 4.8, 5.0 or 5.6 now. That would make a difference.
I used those variables in 4.8 but they do not seem very necessary any more. But
in my config I have set so maybe they make a difference.
PFBIXNODESIZE=24
PFBIXBUILD=2
PFNUMIXBUILD=20480
PFNUMIXBUF=500
Stuff works great so they might help. (My customer is using 5.0 on this system
on Linux)
Don't have the MAX ones at all.
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
More information about the Filepro-list
mailing list