Re: streaming binary data from sql 2005

the technique is the same. you will gain a performance boost if you switch
to a varbinary(max) column over image. there are improvements in
transferring the data.

note: using asp.net for downloads is problematic. asp.net has a limited
number of request threads and a limited number of connection from the
asp.net worker process to .net isapi filter. this means you can not support
a lot of simultaneous downloads. even though its heavy on resources, you
might fiond buffering the download is best. this fress up the asp.net worker
thread quicker.


-- bruce (sqlwork.com)


<param@xxxxxxxxxxxxxxxx> wrote in message
news:unE2osD8FHA.3416@xxxxxxxxxxxxxxxxxxxxxxx
> Hi all, is there a better way to stream binary data stored in a table in
> sql 2005 to a browser in .net 2.0? Or is the code same as in .net 1.1? We
> noticed that in certain heavy load scenarios, every now and then the
> client would timeout and have to re-initiate the request...
>
> TIA!
>


.

Loading