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