RE: Images in DB -- Need your suggestion

Other than performance one also has to look into backup and recovery.

If the image *HAS* to be recoverable alongwith the corresponding rows, then u should make sure that the image files on the OS go with row backups. In such a case its easier(for backup and recovery) to keep the images in a blob. Or u shld be ready with scripts and operational procedures for backup of image files with ur oracle backups.

As far as (blob) performance is concerned cant u come up with some midtier cache for the images. (9iAS Cache perhaps???) For eg keep a cache of most used image files in memory/filesystem for faster retrieval. Every time the db starts retreive the images (accessed in the last 3 months) from the blobs and store it on the filesystem/cache.

-Mandar

> -----Original Message-----
> From: Prem Khanna J [mailto:jprem_at_kssnet.co.jp]
> Sent: Tuesday, May 13, 2003 12:57 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Images in DB -- Need your suggestion
>
>
> Guys,
>
> performance being the issue,
>
> would it be better to store images in Oracle DB (9iR2) or in
> o/s (RH linux) file system ? no update/editing of the image
> will be done.
>
> ..just insert/retrieve the images using JSP.
>
> let's us assume that java coding will be done perfectly ;)
>
> all i need is the performance.
> that is fastest method of doing the above.
>
> what would be the choice of u guys ?
> how would u go about deciding it ?
> what factors affect these decision ?
>
> kindly let me know guys.
>
> Regards,
> Jp.
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Prem Khanna J
> INET: jprem_at_kssnet.co.jp
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mandar A. Ghosalkar
  INET: mghosalk_at_byer.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).