Home All Groups Group Topic Archive Search About

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

Author
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

Author
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
Author
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 quoteHide 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
>