From marin@sirma.bg Fri, 06 Apr 2001 03:08:15 -0700 From: "Marin Dimitrov" Date: Fri, 06 Apr 2001 03:08:15 -0700 Subject: Re: BLOB vs. B-File Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: BLOB vs. B-File  
----- Original Message -----
From: Yttri, Lisa To: Multiple recipients of list ORACLE-L Sent: Thursday, April 05, 2001 18:26 Subject: BLOB vs. B-File 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:   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"