>Hello All
>I have been using an in house designed contact manger using about 30 tables. We could have up to 10 clients running the interface working with the common data. In the past few years our main table contacts.dbf has grown from 10,000 to 20,000 records. The data is on a Win 2003 server. For the past few months I have gotten complaints from users about performance. Lets say a search is done and what took a few seconds in the past could now consume 20 seconds. This may not seem much but all that time does add up as far as user productivity. I believe I have ruled out cabling, switches, hardware, and viruses on the network. Is their some sort of utility that is commonly used to determine where the slowdown is actually occurring? Would MS Network Moitor help? Thanks.
Hi Richard,
If there was no significant code changes to the application and the performance suddenly drops, you may want to think about this outside-the-box possible solution. Remove the network between the executable and data. We noticed that the more indexes are in the CDX, the slower the access tends to be on a networked data. And if you're using updatable VIEWS then that can compound the problem.
Our rule of thumb is that: The EXE and data should reside on the same server whenever possible. VFP is so painful when the data is on a network. So I would check the possibility of using RDP access to the server.
My 2 cents.
ramil
~~ learning to stand still