Hello John and everyone,
Please excuse my jumping in here, but I have a question about this very statement: VFP does data better.

We are working in VFP6 at the moment. Our clients have a lot of data in our vfp tables, and most of our applications access this data for report purposes. So, most of the time we are doing reports. And the reports at the big sites are huge. At the moment, we you native vfp to access the data and build the reports (Data Sessions and cursors opened directly from the tables). The reports are fairly fast. We are looking at accessing the data from the other ways availble, SQL pass-through, ADO, and XML. I have a ugly Select statement that I am testing on our biggest site to see how the times of execute are different. At the moment, I only have native vfp on the same computer, native vfp from a mapped drive and SQL pass-through. The results so far are 6 minutes on the mapped drive and the sql pass-through has been running for 20 hours and is not done yet.
I did a smaller test on the same database and got 2 minutes on the server, 15 minutes on the mapped, and 6 minutes on the SQL pass-through.
How can there be such a difference?

Beth