Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Arrays, maximum lenght?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00447632
Message ID:
00448413
Views:
8
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform