Re: BLOB and performance

My rule of thumb is to use the O/S
for small numbers of very large objects
and the database for large numbers of
small objects. The latter because it
is (seems) easier to keep a catalogue
of millions of items in a database anyway and filesystems are a bit awkward to
handle when you start tracking very
large numbers of objects.

The choice of in-line / out of line for storage may be a moot point for your system, and the 8K sizing means you may want to play around with block and CHUNK sizes at the smaller end of the scale to avoid wasting lots of database space.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

IandB wrote in message ...


>I was wondering about the performance issues of using a BLOB to store small

>images.

>How does it compare to file access ?

>Does it take extra DBA work ?

>How does it influence backup/restore times ?

>

>Our BLOBs have an average size of 8k and we do have plenty of them (about

 10


>million).

>We are working with PROC in a UNIX environment.

>

>Any links to good performance measures would be appreciated

>

>