Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP index sizes
Message
De
21/02/1997 09:26:56
 
 
À
21/02/1997 05:57:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00021491
Message ID:
00021510
Vues:
30
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform