Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Am I used to VFP perfomance ?
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00710650
Message ID:
00710896
Views:
15
>> 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
Map
View

Click here to load this message in the networking platform