Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL very slow in on new network
Message
De
08/02/2006 10:21:23
Luis Navas
Independent Consultant
Auckland, Nouvelle Zélande
 
 
À
08/02/2006 09:20:20
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
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01094616
Message ID:
01094643
Vues:
9
Any antivirus running?

Luis
>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 VFP 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 VFP 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
I never forget a face, but in your case I will make an exception :-)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform