Re: LOBS or not ?

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> schrieb im Newsbeitrag news:3AFE35E9.5C604710_at_exesolutions.com...
> Markus Fischer wrote:
>
> > Hi,
> >
> > For some Webapplication articels are stored in an Oracle DB. They
 sometimes
> > can exceed the normal varchar column size of 4000 chars. Up today
 they're
> > just stored in multiple 4000 char-sized columns. So, in PHP, its quiet
 easy
> > to select an article by doing 'SELECT * from Article WHERE id = 100' and
> > then concatenating the columns in the right order.
> >
> > Is there any advantage of using LOB's here ? Using LOB's from a
> > programmatically view needs some overhead to get dealt with.
> >
> > thanks,
> >
> > - Markus
>
> I don't think it is a question of advantages. It is rather a question of
 the
> fact that you have no choice but to use LOBs. There is nothing else larger
 than
> 4K bytes that will be in the next version of Oracle AFAIK.

    I know but you can also solve this limitation by creating more columns with 4kb or create a second table with a single 4k column and do multiple entries if an text article or whatever is too long.

But, is there any advantage using LOB <-> multiple 4k columns ?

Just looking at the SQL query it's more overhead to deal with LOB's.

• Markus