Re: What are performance implications of using BLOB

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...

Open ended questions can best be adressed by - STOP TOP-POSTING
- Read the Fine Manual.

In the latter case you would read you can store LOBs in separate LOBsegments, outside the actual record.

Why is everyone in this forum too lazy to do any homework?

-- 
Sybrand Bakker
Senior Oracle DBA