Re: LOBS or not ?

Markus Fischer wrote:

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

Multiple 4K columns? How many 2? 3? 4? 100? Perhaps you should reacquaint yourself with the concept of normalization. <g>

Of course you can do it that way. But why use a relational database if you are going to go that route?

Daniel A. Morgan Received on Mon May 14 2001 - 01:07:14 CDT