Fair comment. I guess that if the figures were reversed we'd all go for
standard store elsewhere LOBs and there must be a tradeoff somewhere in
between. And assuming that Nuno is correct about the performance (I haven't
tested) it probably depends on the nature of the data access. I guess I was
probably assuming that generally LOBS are of *about* the same size, i.e you
are storing 8k images or 100mb video streams but not both in one column.
This is almost certainly a bad assumption.
So um I guess what I am saying is that my gut reaction is almost certainly
100% wrong and 'it depends on data,access, etc etc' is in fact correct.
--
Niall Litchfield
Oracle DBA
Audit Commission Uk
<ctcgag_at_hotmail.com> wrote in message
news:20031117190936.052$Ug_at_newsreader.com...
> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote:
> >
> > I'm not sure that I necessarily think that in-line LOBS are *ever* a
good
> > idea. ISTM that in nearly all the cases where an inline LOB would be
> > appropriate, then a Varchar field would probably be a better thing to
do.
>
> I have a column where 99% of the entries are less than 4K, but I wish
> it to work 100% of the time. An inline LOB seems to be a pretty good
> trade-off.
>
> Xho
>
> --
> -------------------- http://NewsReader.Com/ --------------------
> Usenet Newsgroup Service New Rate! $9.95/Month 50GB
Received on Tue Nov 18 2003 - 04:11:09 CST
