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 |
|
rbarlow
Starting Member
26 Posts |
 Posted - 2007-05-11 : 15:43:27
|
| I have a strong feeling that this isn't possible but I thought I might as well ask...I'm developing a database application (SQL Server 2000 backend) where the client and the server is separated over a slow network connection (satellite). There are parts in the application where I will have to query a large resultset so I was wondering if there is a way to determine the percent complete of a query so I can put a progress bar on the interface so the user can see it loading data instead of having a frozen form.I thought about spliting up the query into different ones and update the bar once each separate one is complete but I'd rather not do that because in the application development environment I'm working in, I have to close the resultset and reopen it every time I do a query... unless this isn't a big deal but I'm under the impression its something to avoid.Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-11 : 15:46:17
|
| It is not possible to determine how far along a query is.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rbarlow
Starting Member
26 Posts |
Posted - 2007-05-11 : 16:08:47
|
| Yeh thats what I was thinking... can't hurt to ask though I suppose.Does anybody have any suggestions on querying large amounts of data on a slow connection? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-11 : 16:12:13
|
| in ado.net 2.0 you have the option to execute a datareader asynchronously.that way you front end is still responsive.small batches can be the way to go here._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-11 : 16:12:26
|
| How many rows are we talking about?Could you have the user page through the results so that only small sets are returned at a time?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Track Query Execution