Re: What are performance implications of using BLOB

See my blog entry on BLOB:
http://db360.blogspot.com/2006/11/get-bolder-with-lobs-manipulation-in.html. If you don't need flexibility then, the most efficient (in terms of performance and overhead) is LONG streaming.

Kuassi

goyald_at_gmail.com wrote:
> My question is open ended. I have some optional data > 4 KB (can be
> much larger ~ 500 KB per master record). Data comes to me from another
> system. At this time I have option of just ignoring that piece of data
> and not storing (I will be storing remaining columns). concern is that
> someone may need that data in "future". One idea was to store this data
> in a BLOB in a compressed format.
>
> Assuming that my usual daily SQL fetch operations will not be accessing
> BLOB column, is there a performance impact if I have a BLOB column in
> my table that contains some large 500KB-1MB data.
>
>
> Thanks
>
>
> Frank van Bortel wrote:
> > goyald_at_gmail.com schreef:
> > > Friends
> > > I am trying to find some details on this subject. Can someone please
> > > share their experience? I will be using JDBC drivers.
> > >
> > > thanks
> > >
> > As compared to what?
> > varchars?
> > clobs?
> > external files?
> >
> > Varchars may not work for you - storage only to 4kB,
> > variables up to 32k.
> >
> > --
> > Regards,
> > Frank van Bortel
> >
> > Top-posting is one way to shut me up...
Received on Mon Jan 08 2007 - 20:41:03 CST