Re: bfiles

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Tue, 27 Apr 2004 08:14:24 -0600
Message-id: <408E6AC0.4EB6C8F@sun.com>

Peter,

I worked with a system that is almost identical to what you are asking. We encountered several problems.

The files contained data that the database used as search criteria. However, the data in the files was not directly searchable, so the publish process had to externally indentify the search terms, associate files with them, index, etc. Not very flexible.
Recoverability was compromised as the data was stored inside and outside the database. It was possible that the systems could get out of sync.
Related to 2), the product side decided to request an HA implementation with near-real-time change propogation. Again, the internal/external locations of data caused problems.

My opinion is that this is not a good solution for dynamic, searchable data without a lot of architectural work. I'd love to hear the lessons from someone who has successfully implemented and supported this kind of system.

Daniel

Peter Barnett wrote:

> We have a web application that will be storing a lot
> of .pdf files. Naturally, response time is an
> important criteria. On the surface, it looks like
> bfiles might be a good option.
>
> Any experiences with bfiles? Any opinions pro or con?
>
> =====
> Pete Barnett
> Lead Database Administrator
> The Regence Group
> pnbarne_at_regence.com

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Apr 27 2004 - 09:20:54 CDT