Retrieving 1 large sql record - progress bar possible? vb.net 2005 sql2000

  • Thread starter Thread starter Chris Thunell
  • Start date Start date
C

Chris Thunell

I have a sql database that stores documents (word and excel files) inside a
field. These documents can be 10mb or larger in size. When running on my
local network the files load very quickly, but on remote networks it runs
quite slow. I'm wondering is there a way to measure how much data has been
received from that field... and use a progress bar so the user doesn't think
the application hasn't locked up? I'm not downloading multiple records...
just 1 record with a couple of fields in it... one of the fields being VERY
large.
Any thoughts in vb.net 2005? I'm using sql2000.
Thanks for your help!
Chris Thunell
(e-mail address removed)
 
Chris,

Is it not more clever first to Zip it and unzip it when you get it.

Healing the problem is in my idea better than showing the problem.

Just my thought,

Cor
 
Even Zipped... the file can be quite large.
Thanks for the idea though!
Does anyone know how to get percentage of a record being retrieved?
 
Even Zipped... the file can be quite large.
Thanks for the idea though!
Does anyone know how to get percentage of a record being retrieved?
Click to expand...
Chris,

If you just want to inform the user that the operation is still in progress,
VS2K5's Progress bar has a marquee setting that constantly scrolls the bars in
the progress bar until you tell it to stop, but it will not measure the percent.

It's precisely designed for your situation.


Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com
 
Back
Top