Progress Bar for calls to SQL from .Net

Question

I'm wondering if there is a tried/true method for reporting the progress of a DB call from a .Net application to its user. I'm wondering if it's even possible to actually indicate a percentage of completion, or is the best/only approach to simply display a "loading" animation to indicate that something is happening?

Also, does SQL2008 address this to anyone's knowledge?

Answer 1

You have to load things deterministically. For example if you know that you'll be fetching a lot of data, for example, you might do something like:

-get a count of all of the records -get 500 of them -report status as 500/total % -get 500 more -report status as 1000/total % -... continue until you've gotten them all of the user has canceled

This would be incredibly wasteful on something that takes no time at all, since the mere fact of going to the database is a large part of the overhead.

Answer 2

As far as I know there is no way to do this. My suggestion is use one of the circular progress bars that just spins forever. Microsoft uses these in database operations in SQL and Project.

Here is an article on CodeProject that has a variety of these:

http://www.codeproject.com/KB/vb/sql2005circularprogress.aspx?fid=324397&df=90&mpp=25&noise=3&sort=Position&view=Quick&select=2205952

Adam Berent

Answer 3

how did you solved this? i'm searching for the same thing, no relevant results so far