Re: bfiles
- From: Peter Barnett <regdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 27 Apr 2004 14:24:13 -0700 (PDT)
Daniel,
All valid points. And, it gets worse, this database
would have a standby database. We would have to copy
the external files to the standby server. Sounds like
a maintenance nightmare.
--- Daniel Fink <Daniel.Fink@xxxxxxx> wrote:
> Peter,
>
> I worked with a system that is almost identical to
> what you are asking.
> We encountered several problems.
>
> 1) 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.
> 2) Recoverability was compromised as the data was
> stored inside and
> outside the database. It was possible that the
> systems could get out of
> sync.
> 3) 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@xxxxxxxxxxx
>
>
>
----------------------------------------------------------------
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
----------------------------------------------------------------
> To unsubscribe send email to:
> oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> //www.freelists.org/archives/oracle-l/
> FAQ is at
> //www.freelists.org/help/fom-serve/cache/1.html
>
-----------------------------------------------------------------
=====
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne@xxxxxxxxxxx
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
