Cor Ligthert [MVP]
5/5/2008 5:28:00 AM
Roy,
>I don't think it is the List.Add(...). I have tested by replacing the list
> with an array and it does not affect. I think the bottleneck is the copy
> of
> the bytes from data reader to a local. I don't know which is the way for
> best
> performance for a data reader column with underlining varbinary(max) type.
>
If that would be the case, then why not with an integer, however in my idea
can reading blobs as they have a little bit large size be terible slow.
Cor