Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2000 Server
Wyse Winterm is a 'dumb' terminal. It served as a workstation for terminal service/Citrix.
I have completely uninstalled OneCare, and turned off NAV realtime monitor on the server.
>What is "Winterm"?
>
>Has A/V been turned off at workstations too?
>
>>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
Précédent
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