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 |
|
clarayeung
Starting Member
3 Posts |
 Posted - 2007-06-26 : 22:33:38
|
| The response time when selecting records in client machine is slower than in server.(same select statement is running, it spends more than 5 seconds to retrieve around 30000 records in Client PC but it processes less than 1 seconds in server.)The main reason is the client processing time is great.Does anybody know what affect this problem?Thanks in advance,Clara |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-26 : 23:16:56
|
perhaps it's the network? what is the client doing with the rows?
elsasoft.org |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-26 : 23:23:08
|
| Did you run query in sql tools on client machine? |
|
|
|
|
|
|
Problem in response time when selecting records