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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DENNIS WILLIAMS Sent: Wednesday, April 14, 2004 2:09 PM To: 'oracle-l@xxxxxxxxxxxxx' 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@xxxxxxxxxxxxx=20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------