>>>
>I can't actually believe this myself, a Fox app, querying its own data is slower than a C#.Net querying fox data - whoa!!!
>>>
>
>Not sure this should be a total surprise. Without diving into this in great detail, could it be that the Fox OLE-DB Provider is more efficient than querying data in the native VFP environment? Regardless of environment, you still have rushmore. And, regardless of environment, you are still dealing with a file-based system. That said, I don't think the issue relates to network traffic. Although, it could be that .NET is a better/more efficient network client than Fox accessing tables natively.

Whatever the reason for the performance gain, what my test results show is that .Net is not slower than Fox, which is what a lot of people seem to assume, I'm mainly surprised because I was under the impression VFP accessing native data was far superior to using OLE DB.

I've tried this without having the network overhead, you'll see those results in another thread I've posted.

>
>You should submit this to the vfpconversion.com folks....(although my guess is that they are aware of it already...).

Never heard of this site, I'll have a look...

>Too funny....

Now now.....:-)

Kev