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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Storing blobs in database vs filesystem

RE: Storing blobs in database vs filesystem

From: Matthew Zito <mzito_at_gridapp.com>
Date: Tue, 3 Oct 2006 15:21:45 -0400
Message-ID: <C0A5E31718FC064A91E9FD7BE2F081B1804A30@exchange.gridapp.com>

 

Yep, and in our case, we hashed our directory structure in a na´ve-but-human-readable way of (first letter)/(second letter). So, gridapp.com in the DNS tree would have been in: /path/to/filer/g/r/gridapp.com.

Obviously, /s/t/ was significantly busier than /y/q/, but still, it kept us down to in the 100s of thousands of files per directory on the high end instead of millions. And even then, we had to use Netapp, as all of the commodity filesystems would blow up whenever we had to do mass nameserver reloads.

Matt

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kevin Closson
> Sent: Tuesday, October 03, 2006 2:51 PM
> To: ORACLE-L
> Subject: RE: Storing blobs in database vs filesystem
>
> I wouldn't say that filesystems are built for efficient I/O
> to the contents of files. Actually, once a file is open, most
> of the hard work of a filesystem is over. Depending on how
> files are allocated (maps, extents, whatever), the
> positioning and read/write calls are really no big deal. It
> is the manipulation of file attributes that is tough for
> files. I'd say there are not many (if any) filesystems that
> can readily handle millions of files in a directory.
> Video rendering farms
> do often times need such structure, so we are working on
> optimizations for such here, but that is not our bread and
> butter either.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 03 2006 - 14:21:45 CDT

Original text of this message

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