Home » SQL & PL/SQL » SQL & PL/SQL » BLOB & BFILE Advantage and disadvantage (BLOB & BFILE Advantage and disadvantage)
BLOB & BFILE Advantage and disadvantage [message #274315] Mon, 15 October 2007 09:20 Go to next message
jaagira
Messages: 9
Registered: August 2007
Junior Member
Hi,
We are looking into storing documents as part of application..
Can somebody describes which scenario best fits for blob's or B FILES?? I know one BIG disadvantage of BFILE is , "its not part of DB transaction", but if thats been accepted then would BFILE is better in BLOB storage? Please advice/comment...If anybody knows some document , please post that link.

Thanks in advance.
Re: BLOB & BFILE Advantage and disadvantage [message #274327 is a reply to message #274315] Mon, 15 October 2007 10:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

would BFILE is better in BLOB storage?

Yes for an obvious reason, BFILE are not Oracle structured file, with BLOB Oracle adds its own structure.
And this is the only advantage of BFILE.

Regards
Michel
Re: BLOB & BFILE Advantage and disadvantage [message #274355 is a reply to message #274327] Mon, 15 October 2007 14:47 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
there are many differences to consider. External files aren't part of the database backup. This means your Oracle backups are smaller (can be an advantage), but on the other hand - your Oracle backup is of little use if you don't have the BFILES. It's easier to control access to the content if it's in the database. At the OS level, it's easy to diff, grep, strings checksum etc that can be more of a challenge once in the DB. There are no absolutes - you need to decide what makes most sense for you.
Re: BLOB & BFILE Advantage and disadvantage [message #274581 is a reply to message #274315] Tue, 16 October 2007 08:41 Go to previous messageGo to next message
jaagira
Messages: 9
Registered: August 2007
Junior Member
Thanks Michael,Andrew for comments.

What about BLOB vs BFILE performance. Is there any impact if its BFILE or BLOB for
1) Saving file
2) Opening file..etc..Generally which should be faster and why?

unfortunately I didn't find any Oracle document describing pros/cons in BLOB/BFILE.Thanks for sharing your knowledge.

Re: BLOB & BFILE Advantage and disadvantage [message #274584 is a reply to message #274581] Tue, 16 October 2007 08:45 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Application Developer's Guide - Large Objects

Regards
Michel
Previous Topic: I am creating one file using utl_file package
Next Topic: Tracing procedures, triggers, executions
Goto Forum:
  


Current Time: Sun Dec 11 04:29:22 CST 2016

Total time taken to generate the page: 0.25761 seconds