Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
WAN and Visual FoxPro Database (Data Accessing speed)
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00276225
Message ID:
00276887
Views:
29
If you are sending data over long distances, it may be time to switch to SQL server on the backend. VFP is file server database, it needs to load the entire file inorder to do anything with it. On the other hand, SQL Server runs in its own process and only sends query results. It uses much less bandwith.

Charlie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform