Re: Documents in or outside the database.

From: M.Godlewski <mcgodlewski_at_yahoo.com>
Date: Mon, 15 Sep 2003 18:54:24 -0800
Message-ID: <F001.005CFF89.20030915185424@fatcity.com>

Rachel,  

The documents would basically be just attachments the web client would want to view, so bfiles are reasonable.  

Thanks,

Rachel Carmichael <wisernet100_at_yahoo.com> 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" 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: wisernet100_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: M.Godlewski
  INET: mcgodlewski_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

Received on Mon Sep 15 2003 - 21:54:24 CDT