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?
ramil
~~ learning to stand still