When an application points to a record it can read the contents of that record from the buffer. With SQL statements you creat another buffer. SCANs, providing the files are well designed is very fast.
SQL always creats a cursor and a TEMP header. Why not just point and read? With SQL You are pointing - reading- writing - and reading again (plust the excesses of the additional over head for the temp buffers).
If you want you VFP programs to be really crisp and quick - work with SEEK/SCAN, avaoid buffering macros!
>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
Imagination is more important than knowledge