Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP index sizes
Message
From
21/02/1997 09:26:56
 
 
To
21/02/1997 05:57:11
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00021491
Message ID:
00021510
Views:
34
>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.

As Dave said, if this is not the case, whenever you reindex, you should DELETE TAG ALL and INDEX ON TAG... for all tags.

There is no way 2 tags on your tables should give you tripe size of your actual table even if the key is 38 bytes.

Yes, Bill's said indexes are compressed and he's right. :)
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform