Hello Kevin!

I believe you mentioned remote locations from which the tables are queried. If so, then the network traffic would definitely be the most important in performance issues. Would it be possible to get versions of the same tables re-located on the local network? That would create a more consistent environment for your test.

Sorin


>Hi Mace
>
>>During your tests, did you elinate all other variables?
>>
>>I would imagine that network traffic would have a great deal to play in such a test.
>>
>>I also believe your fox code could be more efficient.
>
>I'm open to comments, although I think you'll find network traffic and the efficiency of the SQL are key here, not the efficiency of the fox code.
>
>Bear in mind I'm using one of Fox's biggest virtues to compare here, it's querying it's native tables. The C# app is not only doing that it's doing a considerable amount more...
>
>Kev