Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Large files in a database

Re: Large files in a database

From: Pablo Sanchez <pablo_at_dev.null>
Date: Sat, 22 Mar 2003 18:49:13 -0600
Message-ID: <Xns9346B54779301pingottpingottbah@216.166.71.233>


Steve Kass <skass_at_drew.edu> wrote in
news:b5i7uu$15n$1_at_slb9.atl.mindspring.net:

> Most products probably have a binary-large-object type like
> Microsoft SQL Server's [image], which can hold the entire image. If
> you want the images to be managed along with the rest of the data
> for backup, replication, etc., then there is an advantage to storing
> them internally.

The 'issue' with the above (really for a lack of a better word) is that logging 7MB of data is a bear. Not sure if SQL Server has a 'no log' option for LOBs like ASE.

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com
Received on Sat Mar 22 2003 - 18:49:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US