Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Counting deleted records...
Message
From
15/05/2003 17:32:23
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00788796
Message ID:
00789028
Views:
19
>I think I read somewhere that if a table contains more than 10% deleted records it's really worth packing it.

Sure, the more deleted records there are, the more time VFP will lose in some operations.

This might justify counting the deleted records - but another option is to just make a habit of packing once a month or so.

OK, I think you are right. It can be worthwhile to have at least an approximate idea of the number of deleted records in the larger tables, to define your packing strategy.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform