And don't forget file permissions issues either--especially if there will ever be a firewall between your db and your users. If the docs are in the db, users won't need OS perms to read/write/delete anything on the filesystem...
Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -----Original Message----- Sent: Wednesday, September 10, 2003 10:55 AM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E 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).
