Re: Storing BLOBS, one file or many?

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Mon, 03 Sep 2001 14:33:02 -0700
Message-ID: <3B93F70E.206BF4D0@attws.com>

Jim Poe wrote:

> We have a number of blob fields to store Word documents. Logically, these
> documents are related to multiple tables as a one to many, i.e., QUOTE ->
> QUOTE_DOC, POLICY -> POLICY_DOC, CLAIM -> CLAIM_DOC. We could design the
> storage using multiple related tables, QUOTE_DOC, POLICY_DOC, and
> CLAIM_DOC. Or, we could store all the documents in one table, DOC, with
> appropriate keys to the multiple 'master' tables. Is there a performance
> advantage in using either design? The QUOTE_DOC column/table would comprise
> about 2/3 of all the documents.
>
> Thanks
>
> --
> Jim Poe (jpoe_at_fulcrumit.com)

Oracle is a relational database ... and in most cases ... the advantage goes to using it relationally.

A group of identical tables pretty much violates that concept.

Daniel A. Morgan Received on Mon Sep 03 2001 - 16:33:02 CDT