Oracle-L: RE: Images in DB -- Need your suggestion

From: Regis Biassala <Regis.Biassala_at_datalex.ie>
Date: Tue, 13 May 2003 04:27:33 -0800
Message-ID: <F001.0059777B.20030513042733@fatcity.com>

Store it in the database using BLOB column and also if the application is designed to work with Oracle only then take full advantage of Oracle JDBC extended API

Regis

-----Original Message-----
Sent: Tuesday, May 13, 2003 8:57 AM
To: Multiple recipients of list ORACLE-L

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

This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible.

This footnote also confirms that this message has been swept for computer viruses.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Regis Biassala
INET: Regis.Biassala_at_datalex.ie

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------