SQLite4
Artifact [f77843e55e]
Not logged in

Artifact f77843e55e5c21bf64fdaf68e2bdb6479fcc528e:

Wiki page [LsmPerformance] by dan 2012-11-29 10:41:12.
D 2012-11-29T10:41:12.459
L LsmPerformance
P 497b34e50de18c644bbae3727286e5b0719817cf
U dan
W 628
With version [a9f8129c] on an ext4 file-system. Machine has 4GB main memory. 7200rpm hdd. "hdparm -t" says:

<verbatim>
   Timing buffered disk reads: 372 MB in  3.02 seconds = 123.38 MB/sec
</verbatim>

Command line is:

<verbatim>
   ./lsmtest speed2 -w 100000 -r 100 -f 100000 -system "mt_mode=4 multi_proc=0 autoflush=4M page_size=1024"
</verbatim>

<span style="display:block;width:1200px;height:400px;background-image:url('raw/8019b99629ba811a?m=image/png')"></span>

Final database size is 1214MB.

<verbatim>
# getrusage: { ru_maxrss 838468 ru_oublock 11393088 ru_inblock 80 } (1243136)
</verbatim>


Z cf5f77de23e2dc296275d31dac37f426