>>>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
>>
>>Post a example where XBASE is faster.
>
>I think, that indexseek/seek/KeyMatch is usually faster than Select-SQL.

sure for 1 to 100 indexseek/seek/KeyMatch vs 1 sql select,
but a query's 100% optimized over a dataset with 100 or more rows it must always win,
otherwise is an error of the VFPT

A great advantage of the SQL query is:
- if the VFP engine improves can improve a lot
- the time of execution is relatively high with little dataset,
but it improves with great amounts, therefore the time perceived from the customer is less variable.
A great disadvantage of the query is:
- the probability of having a bug in a sql engine is greater regarding that one of one simple XBASE command