General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only