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

From: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Tue, 13 May 2003 09:26:51 -0800
Message-ID: <F001.00597B74.20030513092651@fatcity.com>

Have you done some testing ?

Check www.houra.fr, (enter 75015 as the zip code). I was the DBA at that site during its development. The images are store on the OS not in Oracle.

For another system, we stored the images in the database to allow the marketing guys to enter the products definition. But for the access from the web, It was faster to store the images on the OS rather than in the database.

Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel (514) 925-7187
stephane.paquette_at_standardlife.ca <mailto:stephane.paquette_at_standardlife.ca>

-----Original Message-----

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

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


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

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

Author: Stephane Paquette
INET: stephane.paquette_at_standardlife.ca

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