Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance Question
Message
 
To
02/08/2000 16:40:20
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00400063
Message ID:
00400175
Views:
15
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform