Re: BLOB vs. B-File

From: Marin Dimitrov <marin_at_sirma.bg>
Date: Fri, 06 Apr 2001 03:08:15 -0700
Message-ID: <F001.002E3A40.20010406015020@fatcity.com>

Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Yttri, Lisa

To: <A title=ORACLE-L_at_fatcity.com
href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

  Sent: Thursday, April 05, 2001
18:26
  Subject: BLOB vs. B-File
  <FONT
  size=2>
  Hi everyone -
  I'm looking for some information based on your   experiences. We have an application that has large objects to   store. They are wondering which way would be better - to store them as   BLOBs within the database, or as bfiles outside the database. My   instincts tell me BLOBs would be better, but I have no actual facts to base   this on.
  Does anyone have any information or know of any documentation   I could review that might help define the differences - re. coding programs to   access the objects, performance, administration, etc.?

The following link (from the Oracle docs) compares BLOB/BFILE security,features,performance,manageability and storage considerations:

<A
href="http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76940/adl06fa9.htm#124246">What Are the Pros and Cons of Storing Images in a BFILE Versus a BLOB?

hth,

    Marin

----"When someone is seeking, it happens quite easily that he only sees the thing that he is seeking; that he is unable to find anything, unable to absorb anything, because he is only thinking of the thing he is seeking,because he is obsessed with his goal. Seeking means: to have a goal; but finding means: to be free, to be receptive, to have no goal. ..."



Herman Hesse, "Siddhartha"

Received on Fri Apr 06 2001 - 05:08:15 CDT