Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select-SQL very slow on new network
Message
De
07/02/2006 22:20:22
Neil Mc Donald
Cencom Systems P/L
The Sun, Australie
 
 
À
07/02/2006 17:25:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01094476
Message ID:
01094533
Vues:
11
Hi,
Sounds like network problems, that is probably why they used Citrix to start with.
Replacing the Winterms with new Dell's won't fix the underlying network problems.
What speed does the network run at, 10Mb?

>A customer just upgraded their network by removing Citrix and the Wyse Winterms and replaceing them with all new Dell Optiplex workstations. Since the change, my VFP app is running dramatically slower when executing an SQL Select. Procedures that used to take seconds are now taking minutes. I initially thought the problem was the temp file locations. In a Citrix/Winterm environment, all the workstations treat the file server as the C: drive. I have changed the program so that temp files are created on individual workstations, and the tables are stored on \\Server\FXAPP (home directory for the application).
>
>I have never run into this problem before and needless to say the customer isn't thrilled. I don't know if this is a problem with the Network configuration, a programming problem, or something else. The network admin has MS OneCare loaded on all of the workstations. The Norton antivirus program on the file server has been there back to the Citrix cobnfig.
>
>Any help would be greatly appreciated.
>
>Larry Morelli
>(248) 640-7114
Regards N Mc Donald
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform