>To all:
> Has anyone ever linked some sort of progress bar to a reindex and pack? The prog bars that I have require an update command every so often.
>
>Thanks.
>
>Jason Nance
>
>Illinois State University
>Office Of Residential Life
>Residential Computing
>
>jbnance@gw.orl.ilstu.edu
Jason,
I don't PACK or REINDEX. I don't PACK becasue I recycle deleted records to save on disk fragmentation. I don't use REINDEX because it depends on an intact CDX header record, and the time people usually want to reindex that header may very well be damaged.
Instead of reindex I use StoneField Database Toolkit to recreate the indexes. I use the toolkeit because its reindex routines take care of the relations in teh database that are destroyed when a REINDEX is issued. Essentially, what Stonefield does is to save teh relations, destroy the CDXs , recreate each tag with an INDEX ON comamnd, and then restore the relations.