Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pack
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Re: Pack
Miscellaneous
Thread ID:
00775371
Message ID:
00775688
Views:
20
>Issam,
>
>You must use exclusive to pack, there is no way around that.
>
>However, another approach to the problem of accumulating deleted records is to recycle them. That is, whenever you want to add a new record, first look for a deleted one. If you find a deleted record you can;
>
>
>SCATTER MEMVAR MEMO BLANK
>GATHER MEMVAR MEMO
>RECALL
>
>
>and use that record as your new one. Doing this will mean that you should never have to pack the table as new records will use the old deleted ones.

We use this in our event data loggers, where we commonly add 20000 or more new recs every day. The only problem with this, is that the cdx keeps growing, so from time to time we need to stop the apps, and rebuild the cdx.
Doru
Previous
Reply
Map
View

Click here to load this message in the networking platform