>I have a FVP application running and am astonished
>with the size of one of the CDX files. Its table has approx 440,000 records for a file size of 40 megs. It has 2 indexes whose keys total 38 bytes,yet the size of the CDX file is over 120 megs - around 270 bytes per record. And Bill's VFP help says CDX indexes are compressed! The table also has memo file of around 50 megs. If anyone has suggestions as to whats going on and how the CDX size might be reduced, it would be appreciated.
>
>Regards, Jim

when you reindex, vfp adds the new order to the cdx list and keeps the old info also (roughly doubling the size). instead of reindex, delete all tags and rebuild.