As you are one of the few able to measure and compare Chens products, giving the times for good ol' vfp on same HW would be helpful to all...
If Chen's error fixes introduced marked slowdown somewhere, such info is also helpful and might make it easier for Chen to find areas to polish a bit -
even if main benefit for you is moving to 64OS and/or eliminating one of the few vfp gotchas.
thx
thomas
>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.