| BLOB & BFILE Advantage and disadvantage [message #274315] |
Mon, 15 October 2007 09:20  |
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 #274355 is a reply to message #274327] |
Mon, 15 October 2007 14:47  |
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 |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
