>> Remote views are slow. Pass through cursors are fast - but there is some code overhead to manage database updates. Parametrized should speed either up - but you'll get a better approximation of rushmore by using pass through. <<
You're likely to get more than an approximation. For some reason many FoxPro developers have the notion that FoxPro is the fastest DBMS on the planet lodged in their heads. In fact, SQL Server is faster than FoxPro in most cases, and is MUCH faster under heavy load (i.e. large tables and lots of users). The only advantage FoxPro has over SQL Server is price.
Mike
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