gistfile1.txt

DB     Version: Berkeley DB 5.3.28: (September  9, 2013)
SQLite Version: 3.8.7.4

Testing: 5000 records, Transient DB
                                SQLite              DB
insert integer key          194719/sec     1253132/sec
select integer key         1050199/sec     1739735/sec
insert blob key             157539/sec     1156336/sec
select blob key             629485/sec     1633453/sec

Testing: 5000 records, Persistent (single-user) DB
                                SQLite              DB
insert integer key          190447/sec     1204238/sec
select integer key         1050420/sec     1820830/sec
insert blob key             136806/sec     1065189/sec
select blob key             623986/sec     1319261/sec

Testing: 5000 records, Transactional DB
                                SQLite              DB
insert integer key            4544/sec       15794/sec
select integer key          242789/sec     1006846/sec
insert blob key               3922/sec       13040/sec
select blob key             205279/sec      742500/sec

Testing: 50000 records, Transient DB
                                SQLite              DB
insert integer key          178706/sec     1085658/sec
select integer key          784719/sec     1243750/sec
insert blob key             149496/sec     1053940/sec
select blob key             545363/sec     1222583/sec

Testing: 50000 records, Persistent (single-user) DB
                                SQLite              DB
insert integer key          157635/sec     1019284/sec
select integer key          788556/sec     1218115/sec
insert blob key             135229/sec      939584/sec
select blob key             524240/sec     1074875/sec

Testing: 50000 records, Transactional DB
                                SQLite              DB
insert integer key            2867/sec        9691/sec
select integer key          230989/sec      781384/sec
insert blob key               3290/sec       13823/sec
select blob key             199951/sec      672504/sec

Testing: 500000 records, Transient DB
                                SQLite              DB
insert integer key          150020/sec      210553/sec
select integer key          436806/sec      375766/sec
insert blob key             128773/sec      216230/sec
select blob key             343656/sec      390342/sec

Testing: 500000 records, Persistent (single-user) DB
                                SQLite              DB
insert integer key          141875/sec      242038/sec
select integer key          432130/sec      452617/sec
insert blob key             122101/sec      210586/sec
select blob key             321533/sec      371769/sec

Testing: 500000 records, Transactional DB
                                SQLite              DB
insert integer key            2489/sec        7051/sec
select integer key          175460/sec      306589/sec
insert blob key               2981/sec        6416/sec
select blob key             155790/sec      316833/sec