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

9 Mar 2006 11:39 PM

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
cthun***@pierceassociates.com

10 Mar 2006 7:15 AM

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

10 Mar 2006 4:02 PM

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?

Show quote

"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:Orz$jIBRGHA.5296@tk2msftngp13.phx.gbl...
> 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
>

11 Mar 2006 3:54 PM

Otis Mukinfus

On Fri, 10 Mar 2006 11:02:28 -0500, "Chris Thunell"
<cthun***@pierceassociates.com> wrote:

Show quote

>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?
>
>"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
>news:Orz$jIBRGHA.5296@tk2msftngp13.phx.gbl...
>> 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,

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