Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-13 : 08:21:05
|
| John writes "In the process of trying to troubleshoot an application problem, I ran a query from Query Analyzer on my development machine. It took 20 seconds to return 70000+ rows (340000 rows in table). I ran the same query from a different machine, and it took about 4 seconds. It seemed strange so I ran profiler, and repeated the test. Profiler showed the same results. I asked someone else to run the query from their machine. It returned the results in 4 seconds. Considering that it might be some kind of network issue, I imported the table to my local machine, and re-ran the query. Same results. The original problem appeared in a VFP app that again took an exceedingly long time to run from my machine, but took only a short time to run from other machines. I checked what settings I could, and made sure they were the same between the two machines.I am at a loss at this point and have no idea what could be causing the problem. Any suggestions?John" |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-13 : 09:14:41
|
| sounds network related. Make sure that you are connecting at 100Mbit and not 10Mbit.maybe you might want to look for updated network drivers for your workstation.-ec |
 |
|
|
|
|
|
Query Performance Problem