>Hi Kevin,
>
>>OK folks, I've had time to analyse this a bit more closely. Because the C# app was doing a bit extra I've decided just to time the OLE DB performance as this seemed to be the most interesting aspect.
>>
>>The VFP app carries out the following in the time-test:
>>
>>

Opens the tables
>>

Queries each of the 7 databases, outputing the result to a temp cursor - END OF TEST
>>
>>The C# app carries out the following in the time-test:
>>
>>

Queries each of the 7 databases, outputing the result to a DataSet - END OF TEST
>>
>
>It would be interesting to see the results if you use the vfp ole db provider within VFP itself.

I would, but I've never really used ADO in VFP, maybe if you or someone could give me the equivalent code for ADO then I would be happy to try it.

Thanks
Kev