PolePosition - db4o community

PolePosition
the open source database benchmark
http://www.polepos.org


Participating teams

db4o
the open source object database for Java and .NET
http://www.db4o.com

SQLite
a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.
www.sqlite.org

db4o/8.0.145.14388
JDBC/SQLite
Time Overview


db4o/8.0.145.14388
JDBC/SQLite
Memory Overview


db4o/8.0.145.14388
JDBC/SQLite
Database Size Overview


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Melbourne
writes, reads and deletes unstructured flat objects of one kind in bulk mode
Lap: write

t [time in ms]
objects:3000
objects:10000
objects:30000
objects:100000
db4o/8.0.145.1438
1143
2515
8665
30927
JDBC/SQLite
1197
3737
11314
35305


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Melbourne
writes, reads and deletes unstructured flat objects of one kind in bulk mode
Lap: read

t [time in ms]
objects:3000
objects:10000
objects:30000
objects:100000
db4o/8.0.145.1438
211
183
579
2395
JDBC/SQLite
21
38
113
367


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Melbourne
writes, reads and deletes unstructured flat objects of one kind in bulk mode
Lap: read_hot

t [time in ms]
objects:3000
objects:10000
objects:30000
objects:100000
db4o/8.0.145.1438
57
225
614
2457
JDBC/SQLite
16
32
99
366


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Melbourne
writes, reads and deletes unstructured flat objects of one kind in bulk mode
Lap: delete

t [time in ms]
objects:3000
objects:10000
objects:30000
objects:100000
db4o/8.0.145.1438
883
2595
8204
34076
JDBC/SQLite
360
680
297
474


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Sepang
writes, reads and then deletes an object tree
Lap: write

t [time in ms]
depth:8
depth:10
depth:12
depth:14
db4o/8.0.145.1438
142
329
448
1034
JDBC/SQLite
774
410
605
1931


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Sepang
writes, reads and then deletes an object tree
Lap: read

t [time in ms]
depth:8
depth:10
depth:12
depth:14
db4o/8.0.145.1438
25
45
78
341
JDBC/SQLite
22
75
236
1058


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Sepang
writes, reads and then deletes an object tree
Lap: read_hot

t [time in ms]
depth:8
depth:10
depth:12
depth:14
db4o/8.0.145.1438
17
20
48
173
JDBC/SQLite
18
59
240
1041


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Sepang
writes, reads and then deletes an object tree
Lap: delete

t [time in ms]
depth:8
depth:10
depth:12
depth:14
db4o/8.0.145.1438
155
269
440
1154
JDBC/SQLite
451
468
782
2188


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Bahrain
write, query, update and delete simple flat objects individually
Lap: write

t [time in ms]
objects:1000

updates:100
selects:900
objects:3000

updates:100
selects:900
objects:10000

updates:100
selects:900
objects:30000

updates:100
selects:900
db4o/8.0.145.1438
287
772
3018
12873
JDBC/SQLite
566
898
6073
15368


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Bahrain
write, query, update and delete simple flat objects individually
Lap: query_indexed_string

t [time in ms]
objects:1000

updates:100
selects:900
objects:3000

updates:100
selects:900
objects:10000

updates:100
selects:900
objects:30000

updates:100
selects:900
db4o/8.0.145.1438
244
96
114
134
JDBC/SQLite
70
62
69
69


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Bahrain
write, query, update and delete simple flat objects individually
Lap: query_indexed_int

t [time in ms]
objects:1000

updates:100
selects:900
objects:3000

updates:100
selects:900
objects:10000

updates:100
selects:900
objects:30000

updates:100
selects:900
db4o/8.0.145.1438
171
58
55
54
JDBC/SQLite
61
61
66
62


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Bahrain
write, query, update and delete simple flat objects individually
Lap: update

t [time in ms]
objects:1000

updates:100
selects:900
objects:3000

updates:100
selects:900
objects:10000

updates:100
selects:900
objects:30000

updates:100
selects:900
db4o/8.0.145.1438
241
288
669
563
JDBC/SQLite
323
374
428
535


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Bahrain
write, query, update and delete simple flat objects individually
Lap: delete

t [time in ms]
objects:1000

updates:100
selects:900
objects:3000

updates:100
selects:900
objects:10000

updates:100
selects:900
objects:30000

updates:100
selects:900
db4o/8.0.145.1438
285
467
1282
3708
JDBC/SQLite
246
427
714
1736


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Imola
retrieves objects by native id
Lap: retrieve

t [time in ms]
objects:10000

selects:5000
objects:30000

selects:5000
objects:100000

selects:5000
objects:300000

selects:5000
db4o/8.0.145.1438
114
106
98
96
JDBC/SQLite
88
92
73
75


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Barcelona
writes, reads, queries and deletes objects with a 5 level inheritance structure
Lap: write

t [time in ms]
objects:1000
selects:100
objects:3000
selects:100
objects:10000
selects:100
objects:30000
selects:100
db4o/8.0.145.1438
552
658
1146
3073
JDBC/SQLite
589
749
1739
4027


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Barcelona
writes, reads, queries and deletes objects with a 5 level inheritance structure
Lap: read

t [time in ms]
objects:1000
selects:100
objects:3000
selects:100
objects:10000
selects:100
objects:30000
selects:100
db4o/8.0.145.1438
22
49
163
543
JDBC/SQLite
58
167
600
1865


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Barcelona
writes, reads, queries and deletes objects with a 5 level inheritance structure
Lap: query

t [time in ms]
objects:1000
selects:100
objects:3000
selects:100
objects:10000
selects:100
objects:30000
selects:100
db4o/8.0.145.1438
10
9
11
9
JDBC/SQLite
5
12
9
8


db4o/8.0.145.14388
JDBC/SQLite
Circuit: Barcelona
writes, reads, queries and deletes objects with a 5 level inheritance structure
Lap: delete

t [time in ms]
objects:1000
selects:100
objects:3000
selects:100
objects:10000
selects:100
objects:30000
selects:100
db4o/8.0.145.1438
481
740
1368
4236
JDBC/SQLite
503
683
1656
3653