Oracle-L: Serving BLOB from the database

From: Manavendra Gupta <manav_at_zycus.com>
Date: Thu, 29 Aug 2002 07:43:31 -0800
Message-ID: <F001.004C288B.20020829074331@fatcity.com>

Hi,

I'm sure there has been discussion in the past about the same, but I'm more interested in the feasibility/performance of serving images (stored as BLOB) from the database.

For a large multi-tier application (client, web-tier, application, database), with about 5 million records upfront (possibly an image associated with each of them), about 300 concurrent users expected, would the gurus recommend serving images from the database? 1.1 The images will not be served in bulk, but one per request (only on the details page would the user get to see the image).
Wouldn't it be better to serve images from a dedicated box, at the web tier? This way I could just farm the web-tier and wouldn't have to worry about the images much?
Is serving images from the database scalable?
What about backups? This data would not change much (once uploaded the user would hardly make any changes).

With Warm Regards,
Manav.

--

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

Author: Manavendra Gupta
INET: manav_at_zycus.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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). Received on Thu Aug 29 2002 - 10:43:31 CDT