Calculating ETA

  • Thread starter Thread starter decrypted
  • Start date Start date
D

decrypted

I am uploading large blobs on a thread and I want to basicaly show a
progress bar. In order to do this, I need to calculate the estimate dilvery
time to the Sql Server. I have tried a number of different ways, none of
which work accuratly.
Does anyone have any idea how to do this?????

thanx in advance
-dec
 
The techniques I use don't provide an opportunity to step in and show
progress--most of the fast ones don't either. Doing so slows down the
process anyway. I use operations that create a data stream and simply suck
the stream down into a local Image variable. What Access and Office apps do
is "guess". That is, they put up a progress bar and increment it with a
background timer. One approach is to guess how long the download is going to
take based on the size of the file and (perhaps) any history of the last
operation. That is, a 10mb BLOB took 10 seconds to download so a 50mb BLOB
should take 50 seconds (roughly). Using this information, you can increment
the progress bar accordingly. Another approach is to simply bump the
progress bar periodically and when it gets full, restart it.

hth

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top