Re: image storage confusion ??

FWIW ... in my last job we stored 13 million CLOB documents (max size of 5KB, stored out-of-line in their own CLOB segments) in an 8.1.7.3 DB under Win2k (2 CPU HP NetServer with 4GB RAM and twenty-three 36GB drives; JBOD). The CLOB documents were all interMedia Text indexed.

"Contains" queries returned results in a second or less, unless the query was not very specific and hit thousands of documents. Java processes loaded up to 250,000 new documents every night and the interMedia index was refreshed shortly thereafter - took up to a couple of hours. The front-end was Cold Fusion, so that's not applicable to your situation.

This ~200GB database had a Standby DB on a sister machine. Everything worked very well. RMan level 0 backups took a couple of hours.

I vote for out-of-line BLOBs in their own tablespace(s) on as many spindles as you can afford.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
JApplewhite_at_austin.isd.tenet.edu

                                                                                                 
                    Stephane Paquette                                                            
                    <stephane_paquette@       To:     Multiple recipients of list ORACLE-L       
                    YAHOO.COM>                 <ORACLE-L_at_fatcity.com>                            
                    Sent by:                  cc:                                                
                    root_at_fatcity.com          Subject:     Re: image storage confusion ??        
                                                                                                 
                                                                                                 
                    12/03/2002 08:32 AM                                                          
                    Please respond to                                                            
                    ORACLE-L                                                                     
                                                                                                 
                                                                                                 

You should/must do a benchmark.
If not, how can you justify your decision ? If your management do not ask for a benchmack then you have bad management (and that's no good for you either...)

Anyway, in a previous life, we did a benchmarck with files of similar size and it was faster on the OS. The environment was Oracle 816/Sun with Vignette Story Server.

HTH

• oraora oraora <oraoraora_at_rediffmail.com> a écrit : > Guys , i posted this already and this time my
  > question is a bit
  > different .
  >
  > I have to store 20,000,000 images of 5k each either
  > in DB ( on
  > win2k) or linux o/s file system.
  >
  > the images are to be displayed over mobile phones.so
  > the time to
  > retrieve the images should be minimum.
  >
  > for this to be achieved , i am confused , whether
  > the images
  > should be stored in o/s file system or in the DB ?
  >
  > --selecting a file from linux o/s file system
  > -------
  > or
  > --querying it from oracle DB ( on win2k)
  > ---------------
  >
  > which of the above will be faster ?
  >
  > all these will be done with java . this being
  > condition , i
  > would
  > like to know ur suggestion guys.
  >
  > my DB is oracle 8.1.6 on Win2k.
  >
  > TIA
  > --
  > Author: oraora oraora
  > INET: oraoraora_at_rediffmail.com
  >
  

  ---

  Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant stephane_paquette_at_yahoo.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: stephane_paquette_at_yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: JApplewhite_at_austin.isd.tenet.edu

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).