>Walter,
>
>If you didn't do anything to optimize the SQL or make sure indexes are in place then there's a huge fallacy in your argument about xbase always outperforming SQL. If you'll give me the message number of the source code you are talking about I'll take a look at it.
>
>I've been doing a lot of stuff with Sybase lately, and hands down for a lot of complicated queries it beats the pants off VFP.
>
>>I didn't try to optimize the SQL command. You might want to check this yourself as the sourcecode is included and the data is available from the VFP 5 sample\data directory.

Thread #305631 Message #305631

If you look at the strategies, you'll soon see that the performance gain is due to the fact that SQL has to store the results onto the disk (in fact making a copy of the data). The xBase equivalent does not make copies but provides the data as needen row by row. so the xBase strategy is saving CPU cycles, HD activity and internal memory. Talk about efficiency !

Walter,