Indexing a file with 3,000,000 records FAST ?

Kenneth Brody kenbrody at bestweb.net
Fri Mar 10 09:28:24 PST 2006


Quoting Mike Fedkiw (Fri, 10 Mar 2006 10:40:24 -0500):

> system
> filepro 5.0.09
> windows 2000 advances server
> P4 2.4 GHz
> 2 gig of ram
[...]
> I have a file with about three million records. Recently I deleted some
> records out of this file. Now I am getting node errors on a particular
> Index. I rebuilt one index this morning and it took over an hour. now
> add up (a-p times 1 hour). That's 16 hours. There has to be a faster/
> better way. I did try setting PFNUMIXBUF=15000 and that helped a little.
> What about PFNUMIXBUILD.
>
> Any help will be greatly appreciated. I am not looking forward to
> fifteen hours of indexing for one file.

Have you tried PFBIXBUILD=2?

http://www.fptech.com/Products/Docs/FPFormat/envvars.shtml#PFBIXBUILD

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com


More information about the Filepro-list mailing list