>>I would imagine this:
>>
>>SELECT * FROM mytable INTO CURSOR mycursor
>>
>>would be faster than:
>>
>>create cursor mycursor (field definitions)
>>select mytable
>>scan
>>scatter memvar memo
>>insert into myCursor from memvar
>>endscan
>
>That's an unfair comparison, as SELECT * FROM mytable without
>any WHERE clause will surely cause a FILTER cursor,
>which would compare to USE mytable. That again is
>xbase code and faster than the sql select.
>
>Bye, Olaf.
To make it a fairer comparison you can easily add the NOFILTER clause to ensure you don't get a filtered (USE AGAIN) result set to compare the time, or add in a where clause.
Besides the speed comparison, you should also take into consideration the maintainability/readability of the code. One line of SQL is less likely to have errors than 10 of xBase code, it is also possibly more self documenting.