Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sudden slow database access
Message
De
14/01/2015 03:15:56
 
 
À
13/01/2015 18:05:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01613560
Message ID:
01613578
Vues:
55
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform