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