You also need to consider replication issues. If you will have another site that needs to store the documents, you will need to include that in the decision. For example, if you store them inside, Oracle can handle the propogation of the documents to the alternate site. If you store them outside, a separate mechanism is required.
Rachel Carmichael wrote: > Compromise? BFILE? > > Unless we are actually trying to search the documents themselves, I > store documents outside the database and store the pathname to the > document location within the database itself. > > --- "M.Godlewski" <[EMAIL PROTECTED]> wrote: > > Hi listers, > > > > We are working on a project that will have documents as attachments. > > The developers want to store the documents outside the database on > > the application server. I want to store the documents inside the > > database for recovery purposes. Is there a white paper or document > > that has performance information for blob/clob storage and retrieval > > database performance information? > > > > TIA > > M. > > > > > > > > > > --------------------------------- > > Do you Yahoo!? > > Yahoo! SiteBuilder - Free, easy-to-use web site design software > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).
begin:vcard n:Fink;Daniel x-mozilla-html:FALSE org:Sun Microsystems, Inc. adr:;;;;;; version:2.1 title:Lead, Database Services x-mozilla-cpt:;9168 fn:Daniel W. Fink end:vcard