Heads up on "reindex"....
Nancy Palmquist
nlp at vss3.com
Wed May 2 12:13:14 PDT 2007
John Esak wrote:
> Hello,
>
> Just got bit by something stupid. I have been using Bob Stockler's "reindex"
> script for years... don't care to say how many... :-) Actually, Jim A. just
> told me it says circa 1985 in it! Anyway, we had a problem today and I just
> quickly did a "reindex" to fix the file and ran again. Same problem... over
> and over. Nothing dawned on me... then after calling everyone I know ... the
> light shined... There were only 16 indexes when Bob wrote that version.
> Now, with 5.6 there are 26! It was index.R that was blowing up. So, if you
> use that program, or any program that only indexes A-P, fix it. Probably,
> these days would be best to just use -ra and be done with it.
>
> Take care,
>
> John
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
John,
-ra is a nice flag but it only rebuild existing indexes the same way
they are currently sorted.
I think a better method is to create a script that records the indexes
and sorts when they are pristine and then use it to rebuild.
I have had many times when a customer has altered the sort on an index
or accidentaly deleted an index and without such a script you are trying
to figure out what index(s) are broken or missing.
BTW - I think Bob's script does this but I can not remember. Long ago,
I made a process to write a menu script when I need a way to rebuild
indexes, since every application I design must have a way for the end
user to rebuild indexes easily it has always been the best way to do it
for my situation. Then they have menu choices to build indexes as they
were originally designed.
Nancy
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