Versions des environnements
Network:
Windows 2000 Server
If select * from returns the entire table (over 50K records) in 0.00 seconds, can I rule out network problems? I only get the delay when I use a 'where' clause (which I always use, I'm just trying to pinpoint the problem)
>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
Précédent
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