>
>I always find Xbase commands faster than Sql(statement) commands.
It may be if you don't learn how to use queries properly. In order for quieries to be fast they have to be at least Rushmore optimizable.
>Any case where Sql statments are faster ?
>Also i would like to know best prsctices where to use what ??
The queries require much less code and eathier to maintain. They're alwys my first choice. If I cannot get speed that is satisfactory I try to optimaze the query by analyzing SYS(3054) report. Sometimes splitting a complex query into a few separate selects may signifanly speed it up also.
The bottom line, it's very rear that procdural code "wins" over a query in my expirience.
--sb--