Re: BLOBS in the database

Hi,

Because there will be upwards of 8000 of the beasties on disk, mostly piddly in size, though some of them much, much larger. (And 8000 is just the start). Having that many small files floating around on disk imposes (or can impose) a performance penalty, since the O/S is not exactly brilliant at handling heaps of small objects, whereas Oracle is.

Besides, I want to protect my images via Oracle backup and recovery techniques, and not have some idiot (ie, me) accidentally move or delete the requisite files by too hefty a flourish of the mouse.

I suppose there is also the issue that for training purposes, I want to know more about working with BLOBS and CLOBS (students get excited about them all the time, and ask the most, er, awkward questions).

Regards
HJR

--
=============================!!=============================
The views expressed are my own only, and definitely NOT those of Oracle
Corporation
=============================!!=============================


"Knut Talman" <knut.talman_at_mytoys.de> wrote in message
news:3B0A3479.4A77FAA6_at_mytoys.de...


> > Where are the good developers when you need one, huh??!

>

> I am not the one you are looking for, I am afraid. I have just

> a question: Why do you want to store the JPEGs *in* your data-

> base? Why don't you just store a link to them?

>

> Regards,

>

> Knut

>

> --

> Knut Talman                            Fon +40 30 72 62 01 411

> dba_at_myToys.de                          Fax +49 30 72 62 01 222

>       The degree of normality in a database is inversely

>                 proportional to that of its DBA