Jim,
A few things:
>I have a 1 million row table with a primary key of RECNO()
This is unnecessary. You can always just issue Goto
x where
x is any record number.
>
>1) SELECT * FROM table WHERE PriKey>=N AND PriKey
>2) SEEK followed by COPY TO ARRAY
>3) SEEK followed by SCAN
>
I would at least experiment with:
SET ORDER TO
SET DECIMALS TO 9
GOTO INT(RAND()*(RECC()-100))
COPY NEXT 100 TO....
This is the most streamlined approach I can think of. In a situation like this you are actually trying to get rid of VFP's helpful optimization stuff, which can't pay back the overhead it chews up.
Hope this helps.