>Hi Al, Thanks for the input. I had already spoken to the network person at the facility about virus software. They had already looked and felt anti-virus was not the issue. I spoke to them again after your post. They turned virus software (MS Essentials) off both on the server and on the workstation from which I conducted my tests. I retested. Sadly, No difference.
Hmm, antivirus is tricky. I first thought of it because your symptoms seemed to closely match issues reported in
http://support.microsoft.com/kb/321550/ etc. Admittedly the articles are old, the product was Symantec and I haven't heard anything bad about MSE with VFP.
In your testing, I for one would want to make sure another workstation had not recently run your app and might still have the tables in its local disk cache. So to really test you would want to isolate the server and 1 or 2 workstations from other possible interference.
If that's not it you probably have to do some diagnostics. Is the "server" showing any performance bottlenecks? Network speed dropped somehow to 100Mbit instead of gigabit?
Any new computers added to the network? With peer-to-peer you can get network Master Browser contention, especially if new machines have newer OSs and therefore believe they should be the browse master in P2P networks.
The problem happening at calendar year end seems slightly suspicious. Has any software subscription expired or gone into a grace period with reduced performance?
Multi-user VFP apps are a harsh test of Windows networking. Everything has to be right for them to run well. Unfortunately it takes only one thing wrong to make the app slow; finding what it is can be a pain.
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