Re: Best way to store images in DB ?

From: Stephane Paquette <stephane_paquette_at_yahoo.com>
Date: Wed, 27 Nov 2002 08:44:38 -0800
Message-ID: <F001.0050DC34.20021127084438@fatcity.com>

I've seen several answers to that post but none of them have asked the question : what will you do with the images ?

If the images are to be queried a lot then do not store them in the database. Keep them on the OS. In a prevoius life, we've benchmarked our site (www.houra.fr) with images in and out of Oracle. Out wins in term fo performance.

We have developed a small system so the managers can entered text for each images. This time, the images were in Oracle in a blob datatype.

Was 816/sun

HTH

• oraora oraora <oraoraora_at_rediffmail.com> a écrit : > Guys,
  >
  > i have to store 20,000,000 images of 5k each in DB.
  > which is the best possible way to do it ?
  > can i store it as BLOB or use UTL_FILE_DIR ?
  > is there any other means of achieving the same ?
  >
  > it's 8.1.6 on Win2k.
  >
  > Kindly let me know.
  >
  > TIA.
  > Jp.
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: oraora oraora
  > INET: oraoraora_at_rediffmail.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).
  >
  

  ---

Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant stephane_paquette_at_yahoo.com

---

Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Stephane=20Paquette?=
  INET: stephane_paquette_at_yahoo.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).

Received on Wed Nov 27 2002 - 10:44:38 CST