Re: multiblock read count

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Fri, 15 Sep 2000 14:51:45 GMT
Message-ID: <39c2427d.6620534@news-server>

On 14 Sep 2000 12:40:29 GMT, Roman Starek <starek_at_pluto.spsselib.hiedu.cz> wrote:

>
>: I have db_file_multiblock_read_count set to 16 and my block size
>: is 4K. I remember reading somewhere that for optimal performance
>: db_file_multiblock_read_count * db_block_size should be 64 KB.
>
> I think 64kb could be increased for modern discs and
>controllers. Maybe there are limitations from OS for maximum IO
>size.
>

Exactly. Most Unix systems won't do more than 64K in one single I/O request. This is not to say they can't be streamed.

Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Fri Sep 15 2000 - 09:51:45 CDT