|
|
Posted by Zvonko on 11/29/92 11:52
So, one more thing.
Let's say that a user clicks a button that executes a stored procedure
which computes some figures: how will my application know when the procedure
is done, so it can get a result on screen.
How to achieve that?
Zvonko Biskup
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns97FC86C30C3CEYazorman@127.0.0.1...
> What we do? Write so fast code, that there is no need for progress bars!
> :-)
>
> The root problem is that SQL Server does not give any progress
> information.
> And that might be just as well. Recall that the optimizer builds the query
> plan from statistics sampled about the data. From this it makes an
> estimate
> of what is the best plan. Any progress information would be based on this
> estimate. And if the estimate is wrong - which is not unusual - the
> progress
> information would be too. I can't speak for anyone else, but personally
> I find incorrect progress information to be worse than no progress
> information at all.
..com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|