Information générale
Titre:
VFP SQL select very slow on new network
Versions des environnements
Network:
Windows 2000 Server
A customer just upgraded their network from a Citrix server with Winterm workstations to a MS 2000 Server with new Dell Optiplex 170L workstations. The Visual FoxPro application is now running the SQL Selects 5 to 10 times slower than before. I have installes VFP9 and a copy of the data on the C: drive of my workstation and compared a very simple SQL command versus running on the server. I even loaded Visual FoxPro on the server to try to compare apples to apples.
select * from Dispatch where impexp="I" took about 5 seconds on the local drive and 25 on the server to pull about 26000 records.
Needless to say this is making parts of my application almost unusable.
The network guy told me to replace \\server\fxapp with \\168.192.0.1\fxapp and that would eliminate any DNS issues. It made no difference. I have disables realtime monitoring on the Norton AV on the server, and uninstalled Microsoft OneCare on my workstation. Still only a slight improvement.
I'm stumped. The customer is NOT HAPPY. Any help would be greatly appreciated.
Larry Morelli
248-640-7114
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement