BLOB resources

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 14 Apr 2004 15:08:51 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00430@EXCHMN3>

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.

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

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

---

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

---

Received on Wed Apr 14 2004 - 15:07:02 CDT