RE: BLOB resources

From: Justin Cave (DDBC) <jcave_at_ddbcinc.com>
Date: Wed, 14 Apr 2004 14:18:33 -0600
Message-ID: <87E9F113CEF1D211A4C30090273018741BBBDD@ddbcinc.ddbc.local>

Depending on what you'll be doing with the images, I would strongly suggest looking into interMedia and storing the data in OrdImage objects. The interMedia User's Guide has a section on "Tuning Tips for the DBA"
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a88786/mm_d ba.htm#598963 that will probably be helpful either way you choose to go.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DENNIS WILLIAMS Sent: Wednesday, April 14, 2004 2:09 PM
To: 'oracle-l_at_freelists.org'
Subject: BLOB resources

I am looking at a new application that will store millions of images, about 70-k each. My instinct is to store them in a blob datatype. I haven't worked with blobs before. Can anyone suggest resources for learning how to configure a scalable database to handle this? My guess is to create it with a 32-k block size. Obviously each row would take at least 3 blocks, and I would want to keep the blocks contiguous.=20

Also, some developers are lobbying for SQL Server. Could it handle this situation?

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com=20

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

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

Received on Wed Apr 14 2004 - 15:17:24 CDT