Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: storing a million of small files Oracle (or other db) vs. File System
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