>>>Yuri,
>>>What is the result sets row count?
>>>Cetin
>>
>>Up to 200 records.
>
>OK. For a moment I thought returned row count was high. For a table with over million records returning 50K+ rows it was around 7-8 seconds to fill dataset for me (C# - and of course not a good comparison as it might be different from table to table).
>Cetin

Cetin, Einar,

The strange thing is that if I use ODBCDataAdapter instead of OleDBDataAdapter, then the speed is compared with that of VFP.

I have heard the opinion that OLEDB performs better for connections using VFP database container than for free VFP tables. What do you think or know about it?