Re: LOBS or not ?

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sun, 13 May 2001 00:21:13 -0700
Message-ID: <3AFE35E9.5C604710@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.

Daniel A. Morgan Received on Sun May 13 2001 - 02:21:13 CDT