[AccessD] OT: FOXPRO compact decrease dbf size - important

It's not a shame that FoxPro doesn't have a compact command, since its file
format doesn't suffer the bloat issue. As for the data itself, when you
issue a DELETE in Fox, all that actually happens is that a hidden flag
column marks the record for deletion. This permits UNDELETE (known in the
command language as RECALL). The PACK command forcibly deletes records
marked for deletion. As for the REINDEX command, it reorganizes the pages of
the index, thus returning disk space to the operating system. Index
fragmentation occurs when the data is updated frequently.

hth,
Arthur

On Jan 30, 2008 10:43 AM, O'Connor, Patricia (OTDA) <Patricia.O'
Connor at otda.state.ny.us> wrote:

> Thanks Arthur
> I did try the REINDEX and that definitely cut the size down. I had tried
> the PACK but wasn't sure whether I had coded it correctly - will try
> again - though it could just be there is nothing to delete.
>
> It is a shame they don't have a similar compact like Access.
>
>