Disk Space for Re-Index/Pack

[Goofus828]

Hi again,
I either read someplace or was told that FoxPro needs 3 times the diskspace when performing a Re-index and/Or a pack.

I have a client with a 1.5 gig dbf with close to 4 million records but a couple thousand are corrupt. the client only has 3 gig free. And I'm cautious about packing/reindexing this file

thanks.
PS Yes I could ask them to free up more space but that is another issue.

 

[DSummZZZ]

You read right. It can use as much as three times the space to reindex files. PACKing will take twice the space because when you PACK a table - for example - MYTABLE.DBF, Fox basically does a COPY TO MYTABLE.BAK FOR !DELETED(), then deletes MYTABLE.DBF and renames MYTABLE.BAK to MYTABLE.DBF.
Keep in mind though, that if there are associated indexes, those automatically get recreated after the PACK.

So you have a couple choices. One is to delete the index file(s), do the PACK, and recreate the indexes from scratch.
Doing the PACK first may free up enough drive space.

Another option is to use a different drive for the temp/swap files while reindexing.
Of course using a different drive will be slower, but it beats running out of space in the middle of the process.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[DSummZZZ]

Actually, when I said different drive, I was thinking network/server drive not local drive.
If you have the luxury of additional local drives then by all means they should be used.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm