>Hi all,
>
>Given a table has 100,000 rows on it and is stored on a network server. We are using remote views to access the tables. We run a process from another server (where the Exe resides) that deletes 10,000 rows and inserts approximately the same number of rows. When there is only one instance of the application running this process; it takes around 15 minutes to complete. However, when there are two instances of the same application running the same process - each accessing a different set of 10,000 records, the performance quickly drops to over an hour to complete.
>
>I've heard that VFP don't do too well on the WAN; my question is: Is there a best practice document regarding VFP and network data?
Do you mean that both of the EXEs (on machines 1 and 2) are accessing the main table (on machine 3) over WAN links (i.e. using VPNs)? You're right, that's not an ideal way to do it.
For best performance you could look at:
- uploading your updates to Machine 3 via FTP or some other method
- setting up a single instance of the application that runs either on Machine 3 or on its local LAN. This instance could take upload files that are queued up and apply them one at a time, thereby avoiding the non-exclusive use contention issues you're running into now.
- the single instance could be on a separate computer on Machine 3's network running something like GoToMyPC, or it could be a separate Terminal Server, or it could be a Terminal Server session running directly on the console of Machine 3
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up