Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Installation, Setup and Configuration
Hi James
SQL Server is what's causing these performance improvements, not ODBC.
>>
>>James,
>>
>>But, you are talking about SQL Server... which accepts the command, and just sends back a result set, which you talk to through the ODBC driver.
>>
>>But, with VFP tables the ODBC driver is also the data engine.
>>
>>BOb
>
>No. I'm talking about VFP. I think the engine is binging down the schema only when using a remote view, but with a local view, the engine is bringing down stuff it doesn't need for Rushmore optimazation. At least that is what is written in the book, "Client/Server Applications with Visual Foxpro and SQL Server". These are my own observations as well. It was rather remarkable. Of course, if you have a good network with pleny of bandwidth, I wouldn't recommend going this route. There are just too many other limitations associated with it.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only