Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Arrays, maximum lenght?
Message
 
À
01/12/2000 11:05:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00447632
Message ID:
00448413
Vues:
13
I only remember it because this was a big thing early on - put all your variables into arrays and you only use a single MV 'slot'. But the 65,000 array elements can really bite you - I just had a client (who swore on a stack of VFP manuals to the original programmer that there would never be more than 10 or 15 items in a specific mover array) call that they now had 11,000 rows and 6 columns and for some reason it wouldn't run.

I'm still boggling that they've been using this mover for a year with increasing numbers and never thought to call about its being slow - it was taking up to 5 minutes to process.

Changed 2 lines of code, it's now cursor based and runs like lightning.

>Thanks for the correction. I could have sworn that I fixed a broken SELECT INTO ARRAY by changing MVCOUNT, but that was a while back...
>
Barbara Paltiel, Paltiel Inc.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform