Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index size
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01111388
Message ID:
01111412
Vues:
18
>>>>When I pack a file - apart from removing references to deleted records - does the index file get optimised in size - or does it get more and more bloated as time goes by?
>>>
>>>The indexes get recreated during PACK.
>>>
>>>>Is there any way of optimising the size of an index file?
>>>
>>>What do you mean?
>>
>>Hi Sergey
>>
>>Well if I were to create the index file from scratch it would be much smaller - Naomi's suggestion
>>
>
>I'm not sure you have the problem to begin with. Did you experiment and confirm, that PACK ends up with bigger indexes than DELETE TAG ALL, PACK, re-create?
>
>I recall it was a problem in VFP8 before SP. Which VFP version you're running?

Sorry - forgot to say - VFP6
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform