December 26, 2007 at 5:19 pm
Hi,
I try to display the progress bar when viewing the report. I need a way to find out how long the query will take. What is the best approaches to do this?
Thanks in advance.
Jimmy
December 26, 2007 at 9:36 pm
There's no way to know this. You could guess, but even the optimizer doesn't know how long. It can guess, but it's just that.
December 27, 2007 at 6:08 am
Even Microsoft seems to have abandoned trying to make progress bars indicate how long something is going to take.
Go with a spinning wheel or something that just indicates that it is running. If you have a nice enough animated gif, users think things take less time. I have used a gif of a puppy running around wagging it's tail and gotten reports of things running much faster without any reduction in time it takes to actually run.
December 27, 2007 at 7:11 am
Heh... if you write the query right, you won't need a progress bar... it'll just be done.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy