Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
OS:
Windows Server 2012 R2
Network:
Windows Server 2012 R2
Virtual environment:
Hyper-V
thx for the update - not something I would have expected to create differences betwen local and remote data storage.
>Hi Thomas,
>thanks for the reply. In the end it was my select query, I had a SUM(IIF(x = 1, y, z)) and this was very slow which surprised me a bit.
>~M
>>Check that temp directory, where cursors also live, points to your local machine and not somewhere on the server.
>>
>>>Hi all,
>>>I'm having a speed issue on a customer site. They have win 7 and several servers. What I'm doing is selecking some fields from a stock file, no speed issues there. then I select some fields from a transaction table, dbf size 655mb and I extract less than 500kb, no speed issue there. Finally i loop through 824 records in a cursor to update 2 fields. this is very fast on any instance of the virtual server. But on the network or another server, different physical box, it's very slow. The speed difference is 5-6 records through the network take as long as 100 on the virtual server. I'd expect some speed reduction but nothing like this.
>>>The entire network is Gb speed and machines are new, less then 3 years old. The server spec is also good, all server 2012, 16gb memory, multiple xeon processors etc.
>>>The onsite tech guy has tried turning off anti virus and firewall and running the program but with no speed improvements.
>>>Any ideas on where to look or what to try?
>>>~M
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