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 |
|
mapperkids
Yak Posting Veteran
50 Posts |
 Posted - 2007-02-14 : 05:48:18
|
| Hi,I have an vb6 application which connected to the SQL server 2005 and use the select statement to query a table which contains 200,000 records, the result recordset will return about 4000 records, then all 4000 records will move into an array and display in the listview.The problem is when the query is running from our remote office (T1 connection to where the SQL server sitting on) , the performance is very slow, it takes about 120 secs to display the data on the listview. I did the ping test from the remote office, the response time is 15-25 ms. Is there anything to do to speed it up? if access the same query locally, it takes only 4 secs.If create the sp on the server instead of use SQL statement in vb, will that help?Thanks! |
|
|
hrishi_des
Yak Posting Veteran
76 Posts |
Posted - 2007-02-15 : 07:13:10
|
| you need to isolate the problem i.e. how much time it takes to execute that sql statements on remote server, and compare it with when you run it locally, you can create a SP and execute it on local and remote server and compare, use DBCC FREECACHEPROC and DBCC DROPCLEANBUFFERS before executing SP's. then v can c if delay is in transamitting data between server and UI.When solution is simple, God is answering…. |
 |
|
|
|
|
|
|
|
Performance issue when access data remotely ?