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_at_216.166.71.233>
Date: Sat, 22 Mar 2003 18:49:13 -0600
Message-ID: <Xns9346B54779301pingottpingottbah_at_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.comReceived on Sun Mar 23 2003 - 01:49:13 CET