Hi Thomas,

I remember a debate about rushmore and the VFP ODBC driver several months ago. On one hand I can't argue about whether or not Rushmore is available through the ODBC driver. On the other hand, I have great performance with huge tables while using the VFP ODBC driver to get at the data.

This may trigger a series of messages but with proper indexes and small result sets, I don't see the VFP PDBC Driver being any slower than native FoxPro.

I'm not sure what 'measureable difference in speed' means, but your message sounds like you're not getting the speed you want from the ODBC driver. I don't get it. I've always seen great performance from the ODBC Driver, except when I do something like SELECT * FROM ... on a huge table.


Guy



>Mike;
>
>My experience using FoxPro tables with VFP vs any other product (VB, Crystal Reports, Cold Fusion, etc.) is that VFP is faster than using an ODBC connection. When I say faster I do not mean microseconds. I work with large tables a great deal and always try to keep data sets being returned as small as possible.
>
>My viewpoint is since VFP can be optimized (Rushmore) and ODBC does not make use of this technology there is a measureable difference in speed of aquiring data. VFP has a fast database engine and ODBC does not. Depending upon what is being attempted the envelope of technology will only allow so much.
>
>Tom