VFPA 32-bit performance using your code, eliminating the local array declaration and changing last loop to into cursor:
Using COPY TO ARRAY, 10000 passes took 0.079; records in result = 5
Using SQL SELECT, 10000 passes took 0.508; records in result = 5
Using SQL SELECT to cursor, 10000 passes took 0.466; records in result = 5
VFPA x64:
Using COPY TO ARRAY, 10000 passes took 0.086; records in result = 5
Using SQL SELECT, 10000 passes took 0.691; records in result = 5
Using SQL SELECT to cursor, 10000 passes took 0.634; records in result = 5
That's with SET TALK OFF. SET TALK ON and it's heaps slower, with COPY TO ARRAY now slowest- e.g VFPA 32bit:
Using COPY TO ARRAY, 10000 passes took 1.865; records in result = 5
Using SQL SELECT, 10000 passes took 1.364; records in result = 5
Using SQL SELECT to cursor, 10000 passes took 1.403; records in result = 5
SET EXCL also seems to make a slight difference, though that's hardly a surprise.
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us."
-- Shakespeare: Coriolanus, Act 1, scene 1
