Database Progress Bar

  • Thread starter Thread starter NuBBeR
  • Start date Start date
N

NuBBeR

Does anyone have a good idea of how to display a rather accurate progress
bar to show how far along a query is? I am executing multiple queries and
would like to have something graphical for the user to see that the program
is still working. Thanks in advance!
 
NuBBeR,

Unfortunately, there really isn't a way to do this (for most DBs, SQL
Server being one of them).

If you have multiple queries executing, then you can give a progress
indicator for the overall operation (over the multiple queries), but not for
the progress of the individual query.

You can still provide something to indicate that the application is
alive. For example, take the search progress bar in windows (it bounces
back and forth, just to indicate it is doing something).

Hope this helps.
 
Nicholas-
Thank you for the feedback! Where can i find the search progress bar?

Nicholas Paldino said:
NuBBeR,

Unfortunately, there really isn't a way to do this (for most DBs, SQL
Server being one of them).

If you have multiple queries executing, then you can give a progress
indicator for the overall operation (over the multiple queries), but not
for the progress of the individual query.

You can still provide something to indicate that the application is
alive. For example, take the search progress bar in windows (it bounces
back and forth, just to indicate it is doing something).

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

NuBBeR said:
Does anyone have a good idea of how to display a rather accurate progress
bar to show how far along a query is? I am executing multiple queries
and would like to have something graphical for the user to see that the
program is still working. Thanks in advance!
Click to expand...
Click to expand...
 
If you're using Sql Server you can trap the InfoMessage event (include some
print statement and even though they aren't error messages, they'll come
back and you can bump the progress bar)
 
Back
Top