Re: Best way to store images in DB ?
At 08:14 PM 11/26/2002, oraora oraora wrote: Guys, i have to store 20,000,000 images of 5k each in DB. which is the best possible way to do it ? I'd vote for interMedia. interMedia image is designed specifically to store images in the database. It may be an extra cost in 8.1.6, but IMHO it's well worth it. Justin Cave Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave 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).
Re: Best way to store images in DB ?
At a very simplistic level: Lots of small things: databases are very good Not many larger things: file systems are very good In your case, then I'd be looking at storing the images in the database hth connor --- oraora oraora [EMAIL PROTECTED] wrote: 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: [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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
Re: Best way to store images in DB ?
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 [EMAIL PROTECTED] 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: [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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ 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: [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).
Best way to store images in DB ?
Lee, 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: [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).
Best way to store images in DB ?
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: [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).
Re: Best way to store images in DB ?
UTL_FILE_DIR is for text files only using utl_file package; not useful for pictures. For pictures you have two choices (1) Use BLOB fields where the picture can be stored in the database. This adds to security and reliability. However, it generates too much redo (and archvive). (2) Use BFILE, where the actual file is stored on the file system and pointer to it is stored in the database. However security is definitely an issue. And how do you plan to back it up? There are other ways like using WebDAV and iFS, but I have no experience in using them. HTH Arup Nanda www.proligence.com From: oraora oraora [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Best way to store images in DB ? Date: Tue, 26 Nov 2002 19:14:20 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc5-f20.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Tue, 26 Nov 2002 20:03:52 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id TAA59053;Tue, 26 Nov 2002 19:58:40 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0050D1CD; Tue, 26 Nov 2002 19:14:20 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: oraora oraora [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 27 Nov 2002 04:03:52.0570 (UTC) FILETIME=[FF66FDA0:01C295C9] Lee, 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: [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). _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arup Nanda 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).