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

Mike Fedkiw mikefedkiw at adelphia.net
Fri Mar 10 07:40:24 PST 2006


system
filepro 5.0.09
windows 2000 advances server
P4 2.4 GHz
2 gig of ram

BTW, I don't want to upgrade to 5.0.14. I am waiting for next ver. Ray said
that the bug slowing browse window scrolling and flickering when using lots
of show commands would be fixed in ver 5.0.15 and above.

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.

Thanks in Advance, Mike Fedko
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20060310/6a6a930a/attachment.html


More information about the Filepro-list mailing list