Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pack
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Re: Pack
Divers
Thread ID:
00775371
Message ID:
00775688
Vues:
19
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform