>> 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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement