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

Home -> Community -> Usenet -> comp.databases.theory -> Re: B*-trees

Re: B*-trees

From: <cbbrowne_at_hex.net>
Date: Fri, 12 Jan 2001 04:17:45 GMT
Message-ID: <wklmsh3cwv.fsf@mail.hex.net>

>>>>> "Christoph" == Christoph Rupp <chrrupp_at_rz.fh-augsburg.de> writes:

>>> Depending on the structure of your data, reading from one file
>>> could also be faster, if one read operation gets more than one
>>> index table. Sure, the head of the harddrive doesn't have to move
>>> that far... now it's clear to me.
 
>> You can never be sure, what the head does.  Typically repositioning
>> the file cursor takes more time than reading a multiple amount of
>> data.

Christoph> Yesyes, that's what i meant. Therefore one file should be
Christoph> faster then several files. Thinking about many fragmented Christoph> files on my hard drive :)

Further complications are available...

-> If the data is cached in memory [competently designed OSes have

   commonly, since the 1970s, offered this feature], the disk may not    get hit for a read operation if the data is already in RAM.

-> Disk drives sometimes lie about what they're doing internally.

   They may claim to have some number of heads/sectors/clusters, but    underneath have other "geometry" so that you don't really know    what's going on.

-- 
(reverse (concatenate 'string "ac.notelrac.teneerf@" "454aa"))
<http://www.ntlug.org/~cbbrowne/>
?OM ERROR
Received on Thu Jan 11 2001 - 22:17:45 CST

Original text of this message

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