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

Home -> Community -> Usenet -> c.d.o.server -> Re: storing a million of small files Oracle (or other db) vs. File System

Re: storing a million of small files Oracle (or other db) vs. File System

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Fri, 22 Jun 2001 12:50:20 GMT
Message-ID: <3b333e19.618401524@news.earthlink.net>

On Thu, 21 Jun 2001 23:41:16 -0400, "Alan L. Stange" <stange_at_rentec.com> wrote:

>
>> e.g., recently a delete of 64K files took a good few hours to complete
>
>
>All in one directory? Do you have UFS logging turned on? Deleting 600
>files took 0.3 seconds on my Blade 100. So, if scale this up to 60K,
>which isn't really fair, I hit 30 seconds. This is obviously to small a
>time, but a few hours is waaaaaaaaay to long. Solaris 8 has some nice
>caching added for directories, use Solaris 8, and make sure you add the
>option in /etc/system:
>set dnlc_dir_enable=1
>

I made a mistake here.. I wasn't deleting, I was moving to another dir on the same disk. Received on Fri Jun 22 2001 - 07:50:20 CDT

Original text of this message

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