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...
>