[prev in list] [next in list] [prev in thread] [next in thread]
List: suse-oracle
Subject: Re: [suse-oracle] LOB/bfile storage
From: Peter Baumann <baumann () rasdaman ! com>
Date: 2005-04-23 8:21:28
Message-ID: 426A0588.8050908 () rasdaman ! com
[Download RAW message or body]
[sorry for reposting, used a non-registered mail address]
Pete-
Can't contribute to BFILEs, we're using LOBs only.
Our middleware stores large multidimensional raster objects in a
partitioned manner, each partition ("tile") going into a blob. Usually
blob size is about 1 MB, sometimes less due to compression. We have
quite some blobs in the database, eg for a 4 TB satellite map we end up
with ~ 4m blobs.
+ performance for insert and read is quite nice, although no rigid
database-centric benchmarks exist up to now (application server delivers
zoomed, recomposed, and processed map in ~.3secs on an AMD 2000+ with 512 MB and IDE disks)
- storage management is a miracle, in particular it seems like Oracle
releases freed blob space only on a drop table 8-()
Conversely, can you please post your findings?
Best,
Peter
pelmgreen@medicinespoon.com wrote:
>LOB / bfile / 10g - linux (sles9/ext3)
>
>For datamigration there's 200000+ pdf documents, each <100kb in size - for
>other situations its likely to be a larger volume.
>
>Documents are readonly - to be delivered to the client via Oracle utils -
>webutil/wpg_docload
>
>I'm looking at a table in readonly tablespace /nologging - using either blob
>or bfile storage.
>
>I've got a benchmark for locating a file in a directory with 100000 files
>(0.02 sec)
>-- is performance likely to degrade significantly if - say its 1million+
>files - build up a directory structure to split up the files in chunks ? or
>for easy mangement/performance is blob storage then superior ?
>
>Just wondering if anyone has done any research of any kind on the query
>performance comparison of using one over the other at db level? Or can
>anyone point me at any docs that
>might do a compare and contrast of the two types of storage and the
>performance ramifications?
>
>TIA
>
>Pete
>
>
>
>
--
Prof. Dr. Peter Baumann
- Executive Director, rasdaman GmbH
www.rasdaman.com, mail: baumann@rasdaman.com
tel: +49-89-67000146, fax: -67000147, mobile: +49-173-5837882
- Professor of Computer Science, International University Bremen
www.faculty.iu-bremen.de/pbaumann, mail: p.baumann@iu-bremen.de
tel: +49-421-200-3178, fax: -3103
"A brilliant idea is a job halfdone."
--
To unsubscribe, email: suse-oracle-unsubscribe@suse.com
For additional commands, email: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting
[prev in list] [next in list] [prev in thread] [next in thread]