show Progress for Long Running Query
-
Dear All, I have a query in SQL 2005 which takes some time to complete during query executation I want to show the progress for the user in asp.net application. I can show Progress bar and I can run the progress of query in the background using thread but the problem exists how can i show the progress based on the query execuation? any ideas? "I think the better approach would be to show seperate dialogbox (Window) from javascript and show the progress at that window."
Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan
-
Dear All, I have a query in SQL 2005 which takes some time to complete during query executation I want to show the progress for the user in asp.net application. I can show Progress bar and I can run the progress of query in the background using thread but the problem exists how can i show the progress based on the query execuation? any ideas? "I think the better approach would be to show seperate dialogbox (Window) from javascript and show the progress at that window."
Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan
Hi Abdul how long is "takes some time" a sec, a 30 sec ? if its a 5 sec max ill go for an animated gif file [here](http://www.preloaders.net/ target=) if not i wont let the user to wait to much for a process do you have to wait for the query to execute ? MyDevBank.com
-
Hi Abdul how long is "takes some time" a sec, a 30 sec ? if its a 5 sec max ill go for an animated gif file [here](http://www.preloaders.net/ target=) if not i wont let the user to wait to much for a process do you have to wait for the query to execute ? MyDevBank.com
Thanks for reply, well the progress is different its based on column selection, the much the colums the much time it takes.It takes less and more than 30 sec in some circumstances.
Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan
-
Dear All, I have a query in SQL 2005 which takes some time to complete during query executation I want to show the progress for the user in asp.net application. I can show Progress bar and I can run the progress of query in the background using thread but the problem exists how can i show the progress based on the query execuation? any ideas? "I think the better approach would be to show seperate dialogbox (Window) from javascript and show the progress at that window."
Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan
The challenge of a progress bar as you noted, server-or client-side, is difficulty of what to base the increment on during the query. Building on the suggestion of the first reply, how an animated gif image that symbolizes the query is running, combined with a counter that increments in seconds as the process running. Also, a message that warns searches could take from X - Y seconds, just so they don't think it's locked up. Those three elements might make the wait more bearable for the user.
Regards, Gary
-
The challenge of a progress bar as you noted, server-or client-side, is difficulty of what to base the increment on during the query. Building on the suggestion of the first reply, how an animated gif image that symbolizes the query is running, combined with a counter that increments in seconds as the process running. Also, a message that warns searches could take from X - Y seconds, just so they don't think it's locked up. Those three elements might make the wait more bearable for the user.
Regards, Gary
Thanks for the reply, but at least there should be something which i should show for the user, maybe i should an animated GIF till recieving the result from backend server. any ideas for animated GIF?
Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan
-
Thanks for the reply, but at least there should be something which i should show for the user, maybe i should an animated GIF till recieving the result from backend server. any ideas for animated GIF?
Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan
I've used images form these sites: http://www.ajaxload.info/[^] http://www.preloaders.net/[^]
Regards, Gary