Manav - I believe that serving images from BLOBs in the database imposes a
significant load on the database, as opposed to simply keeping pointers to
O.S. files. Operating systems are pretty good at this sort of thing or, as
you mention, the Web server. So this is not an issue to be taken lightly.
The key question I heard from an expert was "are you manipulating the images
while they are stored?". In other words, is there any inherent advantage in
having them in the database?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, August 29, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L
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.
1. 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).
2. 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?
3. Is serving images from the database scalable?
4. 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: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [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).
