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) [EMAIL PROTECTED] Stephane Paquette <stephane_paquette@ To: Multiple recipients of list ORACLE-L YAHOO.COM> <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > ===== Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).