Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can you Pack a Cursor
Message
 
 
À
06/11/2012 11:18:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01556496
Message ID:
01556513
Vues:
89
>>I have a Select into a Cursor readwrite and then 'Postprocess' the cursor removing rows based on various conditions
>>I then want to 'Pack' the cursor but dont seem to be able to do it
>>Any way of doing it
>>
>>(After removing rows, I then need to use the cursor as the basis of an update, and want to speed it up as much as possible (can be millions of rows) , so want to Pack to improve performance
>>
>>Tia,
>>Gerard
>
>First of all: yes, a readwrite cursor can be packed. However, I would rather add a logical field for your purpose, and also create a binary index tag on this field. Index on YourField tag yourtag binary.
>
>Update: Sorry, I mixed Zap and Pack, a cursor can be Zapped, but clearly not Packed. But isn't that why we have Set Deleted On as default? Anyway, use an extra field, that's much easier and possibly also quicker in this case.

You beat me to it, again.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform