out of memory index P
Mike Schwartz (PC Support)
mschw at athenet.net
Fri May 12 08:04:38 PDT 2006
> This morning I tried to clean up one of my files.
> I ran fpcopy and made a copy of the file without data
> under a different name.
>
> I then did a lookup to it from the old file to the new
> file and the did a copy.
>
> Rich Tartaglia
I can't speak to this exact error, but whenever I archive a lot of
records, I've found it much speedier to remove all the indexes on the file
I'm copying TO (note the TO), then to do the archiving, then to rebuild all
the indexes on the new file after the archiving process completes.
This would at least be a workaround until you can solve your exact
problem.
I don't know how experienced you are with filePro, but rather than
actually delete the indexes in the new file that you created with fPcopy, it
would be faster to back them up to a different subdirectory, then after you
archive the records to the new file, copy the index files all back in and
use the command line options with dxmaint to rebuild all of them with just
one command.
Mike Schwartz
More information about the Filepro-list
mailing list