"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
news:3fb7d87d$0$3347$cc9e4d1f_at_news.dial.pipex.com...
>
> 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.
Oh, I kinda know EXACTLY why are they a good idea:
you don't ALWAYS get a 2Gb LOB. And they aren't always
very large. That's the definition of variable.
So, in-line ones are quite handy. Particularly since the
access to these for nearly all operations is twice as fast
at least. If not more.
--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
Received on Mon Nov 17 2003 - 03:05:29 CST
