Re: Internal vs. External LOBS

Mark,
  before you decide you should concider:

  External LOBs are not

• concidered as part of the transaction This becomes important for recovery, rollback, etc
• replicated
• part of a DB backup

  If you choose to use external LOBs your application has     to write the file to the filesystem (which the DB     can access) and then create the reference to it.     (LOBs can be read via DB)

  So why use BFILEs ? It reduces the transaction time,    the need of rollback segments and gives more flexibilty    regarding direct update of your documents (the document    can be updated directly on the Filesystem ... or not -    depending on OS privileges)

  For further details have a look at the Developers Guide   for LOB.

Regards
Dante

In article <7h9evf$2ik$1_at_nnrp1.deja.com>,   mmacna_at_ftg-inc.com wrote:
> I am working on an application for underwriters where we need to store
> MS word documents. I am trying to decide on the type of LOB to use
> (internal vs. external/BFILE) and if internal, which type. Some
> characteristics:
>
> 1. About 70 documents/day
> 2. About 40K/document
> 3. Rarely updated once stored
> 4. Using a VB application to launch word for editing, etc.
> 5. Oracle8 on WindowsNT
>
> Any help or experiences would be appriciated.
>
> thanks in advance
>
> Mark
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 11 1999 - 13:50:46 CDT