Unanswered: Data Transfer Problem in Foxpro ERP Application
We have an ERP application running on Foxpro database. There are 2 buildings where our users are situated. They are separated by less then 1 kilometer. They are connected by VPN - 3 Mbps connection. The server is located in one of the buildings and all people access the application through this server. There is an icon of the application on each desktop. The users click on the Icon and it links to the EXE and the database both of which are situated on the server. The problem is when we open a screen to make a Goods REceipt Note etc and click on a drop down menu which is populated with Item Master/ Vendor Master etc it takes us more then 3 minutes to load everything on the screen. All workstations have PIV 256MB Ram. Any solutions for increasing the speed?
Typically the executables should reside on the local machines. This wll reduce traffic substantially. Also maybe a drop down list is not the most effecient way of displaying records to choose from. As an alternative use a BROWSE window or some other way of choosing records.