Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I pack a file/reindex within a form
Message
From
08/08/2006 03:59:31
 
 
To
07/08/2006 04:43:30
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01143376
Message ID:
01143710
Views:
8
Tore,

>If you need to do this from a normal form ment for day-to-day use, you have a serious design problem and should reconsider your design. Packing and reindexing should only be done very rarely, typically once or twice per year. In my case I only pack and reindex when we have a new year.

Partially disagree - IF your indexed values are added in a nearly random order that might be - but almost always where you input data already preprocessed you get the records ordered, and after inserting them a reindex might be helpful to better balance your btrees... Bites me heavily, as I batch-insert host data, but the principle remains.

regards

thomas
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform