Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor VS Array
Message
 
 
À
19/04/2001 14:33:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00497487
Message ID:
00497517
Vues:
17
This message has been marked as a message which has helped to the initial question of the thread.
>Hi all!
>
>I want to know your opinion here.
>
>I'll like to bind some data to some combobox on a form. The data came from SELECT - SQL made by SQLEXEC() from a remote VFP6 database. I want to know if it is better to keep the data in arrays or to keep them in cursors. The arrays or cursors will contain 2 or 3 fields ( 1 key, a description and maybe a code ). Is one more faster than the other? Is one take less memory than the other? etc.
>
>Many thanks in advance!

Arrays take memory variable while cursors in essence do not. Cursors are stored using the temporary workfile space that VFP creates. As such, you can usually have more records in a cursor than rows in an array. Also, there is a distinct limit of 65000 elements to an array. With 3 columns, that gives you about 21600 rows. You may not exceed that, but you never know. < s >
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform