Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Performance Question
Message
 
À
02/08/2000 16:40:20
Jimmy Ditta
Twin City Electronics
Monroe, Louisiane, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00400063
Message ID:
00400175
Vues:
16
You'll waste more time and resources re-opening a cursor that didn't need updating than you will save by closing everything. Old FPDos programs did this because of limited file handles, but (IMHO) you shouldn't close ANY file you might need again.

And remember that opening a cursor also opens at LEAST one underlying table, maybe 2 or more if there are joins. You'd have to program all of THESE tables closed as well.

HTH
Barbara

>If you have a form that uses cursors for browsing through transactions, other cursors for editing a transaction, and still others for creating new transactions, is it better for performance purposes to close the cursors that are not being currently used (to free memory), or leave them open (in the case that they are already loaded and are ready to be used again?
>
>Thanks
>JD
Barbara Paltiel, Paltiel Inc.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform