>hi,
>
>I always find Xbase commands faster than Sql(statement) commands.
>
>
>Any case where Sql statments are faster ?
>Also i would like to know best prsctices where to use what ??
>
>
>TIA
>suhashegde
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
I generally use SQL as my first choice. If it's slow I try tooptimise it with the appropriate indexes. If that's still too slow I look at using xbase code. Sometimes the xbase code is faster sometimes not, but I find SQL easier to maintain and easier to run against a database different to VFP.
HTH,