Re: What are performance implications of using BLOB

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 - 15:07:06 CST