Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index size
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01111388
Message ID:
01111412
Views:
16
>>>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform