PIII 1GHz, ReiserFS 3.6.25 (compiled into the kernel) on a 10,000rpm SCSI drive, linux 2.4.19 (gentoo sources). $BerkeleyDB::db_version == 3.2, $BerkeleyDB::VERSION == 0.20

Benchmark: timing 10 iterations of berkeley write, file write...
berkeley write:  7 wallclock secs ( 4.01 usr +  3.24 sys =  7.25 CPU) 
+@  1.38/s (n=10)
file write: 15 wallclock secs ( 3.00 usr + 10.51 sys = 13.51 CPU) @  0
+.74/s (n=10)
               s/iter     file write berkeley write
file write       1.35             --           -46%
berkeley write  0.725            86%             --
Benchmark: timing 10 iterations of berkeley read, file read...
berkeley read:  2 wallclock secs ( 1.07 usr +  1.21 sys =  2.28 CPU) @
+  4.39/s (n=10)
 file read:  1 wallclock secs ( 0.50 usr +  0.61 sys =  1.11 CPU) @  9
+.01/s (n=10)
                Rate berkeley read     file read
berkeley read 4.39/s            --          -51%
file read     9.01/s          105%            --

[download]

then i changed the 8000's to 800 and the 10's to 100 to see how it would do with smaller files:

Benchmark: timing 100 iterations of berkeley write, file write...
berkeley write: 11 wallclock secs ( 4.83 usr +  5.31 sys = 10.14 CPU) 
+@  9.86/s (n=100)
file write: 68 wallclock secs ( 5.81 usr + 56.34 sys = 62.15 CPU) @  1
+.61/s (n=100)
                 Rate     file write berkeley write
file write     1.61/s             --           -84%
berkeley write 9.86/s           513%             --
Benchmark: timing 100 iterations of berkeley read, file read...
berkeley read:  5 wallclock secs ( 3.49 usr +  2.11 sys =  5.60 CPU) @
+ 17.86/s (n=100)
 file read:  4 wallclock secs ( 2.69 usr +  1.33 sys =  4.02 CPU) @ 24
+.88/s (n=100)
                Rate berkeley read     file read
berkeley read 17.9/s            --          -28%
file read     24.9/s           39%            --

[download]

anders pearson

In reply to Re: BerkeleyDB vs. Linux file system by thraxil
in thread BerkeleyDB vs. Linux file system by perrin

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.