Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wide area connection speed?
Message
From
08/02/2016 19:23:53
Joel Leach
Memorial Business Systems, Inc.
Tennessee, United States
 
General information
Forum:
Internet
Category:
Other
Miscellaneous
Thread ID:
01630948
Message ID:
01631078
Views:
54
>Hi,
>
>A customer is trying to use my VFP 9 application from a computer that connects to the server via WAN. The program runs very slow; queries take a long time. The IT person says that this facility (where PC is located) connects to the main network at 100 mb. Is it very slow? What are the acceptable speeds for a good application performance? What are the typical speeds of WAN?
>
>TIA

I'll echo what the others have said. Maybe things have changed recently, but our experience is that accessing DBFs over a WAN is a bad idea. You are having performance problems now, but you'll probably also see data corruption at some point. I am no network expert, but it has become obvious that WAN != LAN, regardless of how fast it is. The underlying network architecture is not what VFP expects. You'll likely see the same issues with other tools that work directly with data files like Access. This frustrates IT folks that have invested a lot in their high-speed network, but we tell them it will inevitably lead to problems and we cannot support it. If they want remote access, they have to use Terminal Server/Remote Desktop or a similar tool. SQL Server and other database servers should work fine over a WAN, but direct access to data files is where the problem is.
Joel Leach
Microsoft Certified Professional
Blog: http://www.joelleach.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform