>
Conclusion...>
>The OLE DB driver appears to be very efficient - for small result sets, it also peeks higher than the direct Fox query and doesn't dip (ie it's consistent). On larger results however it lags a bit - but bear in mind (in C#) this query is not only retrieving the data, it has to construct the DataSet/DataTable and stuff the data into it - and given the heirarchy of ADO that would appear more work than constructing a temporary cursor - or am I wrong?
>
Kevin,
This was what I was trying to say in that other thread (and demonstrated in December 2003's thread). If there is large amount of data then VFP outperforms .NET. For your test also keep in mind that there is a big difference between exclusive on/off, deleted on/off (be sure they match with OLEDB provider too).
Cetin