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

[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)

 

[Cor Ligthert [MVP]]

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

 

[Chris Thunell]

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?

 

[Otis Mukinfus]

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?

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