Groups > comp.lang.java.databases > #127

Re: In need of advise abo

From	"RedGrittyBrick" <redgrittybrick@THRWHITE.remove-dii-this>
Subject	Re: In need of advise abo
Message-ID	<b4qdnZioxOxukbLVRVnyigA@bt.com> (permalink)
Newsgroups	comp.lang.java.databases
References	<2out241i5ietfedhahm3enk2gq1alh75bt@4ax.com>
Date	2011-04-27 15:21 +0000
Organization	TDS.net

Show all headers | View raw

  To: comp.lang.java.databases
Roedy Green wrote:
> On Sat, 17 May 2008 14:11:36 +0200, Thomas Kellerer said:
> 
>> Most filesystems aren't very good in 
>> handling thousands (if not millions) of files in a single directory.
> 
> 
> Unix has inodes which I presume requires substantial i/o just to list
> the files in a directory.

To just list the (names of) files in a directory requires no access to 
inode tables. File names are stored in directories, not in inode tables.

I think most Unix filesystems (since FFS in '83?) aim to keep metadata 
in the same cylinder group as the corresponding data.

> Any database is going to use some sort of btree with most of tree
> cached in RAM. 

Filesystems like ext3 use Htree (specialised Btree) and RAM caching.

Not that I'm advocating filesystems over databases!

-- 
RGB

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next — Previous in thread | Find similar

Thread

In need of advise about s "mebe" <mebe@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
  Re: In need of advise abo "Dave Miller" <dave.miller@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
    Re: In need of advise abo "David Harper" <david.harper@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
      Re: In need of advise abo "Dave Miller" <dave.miller@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
  Re: In need of advise abo "Jeffrey H. Coffield" <jeffrey.h..coffield@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
    Re: In need of advise abo "=?ISO-8859-1?Q?Arne_Vajh=" <=?iso-8859-1?q?arne_vajh=@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
      Re: In need of advise abo "Jeffrey H. Coffield" <jeffrey.h..coffield@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
        Re: In need of advise abo "=?ISO-8859-1?Q?Arne_Vajh=" <=?iso-8859-1?q?arne_vajh=@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
  Re: In need of advise abo "=?ISO-8859-1?Q?Arne_Vajh=" <=?iso-8859-1?q?arne_vajh=@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
    Re: In need of advise abo "BoBi" <bobi@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
  Re: In need of advise abo "Roedy Green" <roedy.green@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
    Re: In need of advise abo "Thomas Kellerer" <thomas.kellerer@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
      Re: In need of advise abo "Roedy Green" <roedy.green@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
        Re: In need of advise abo "RedGrittyBrick" <redgrittybrick@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000

csiph-web