|
Unusable on spinning disk, these results are from an SSD. |
|
|
|
1M x create node+rel in 38s, 26k r/s |
|
1M x create 2 nodes, 2 relationships, 2 properties in 47s, 21k r/s -> 80k records / s |
|
1M x create 2 nodes with labels, 2 rels, 0 properties in 140s, 7k r/s |
|
100k x create 100 rel + node -> 10M in 20s, 5k r/s |
|
1M lookups by id in 22s, 43k r/s |
|
1M lookup by id compiled runtime in 21s, 47k r/s |
|
|
|
|
|
// 1M lookups and return by id in 17s 57k r/s (not found) |
|
|
|
|
|
|
|
{"statements":[{"statement":"CREATE (_0 {type:'Bike'}), (_0)-[:REL]->(_0)"}]} |
|
|
|
1000000 = 1M x create node+rel in 38s, 26k r/s |
|
|
|
neo@neo:/ssd/ab/test$ sh _run_ab.sh 24 1000000 create_1.json 17474 |
|
This is ApacheBench, Version 2.3 <$Revision: 1528965 $> |
|
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ |
|
Licensed to The Apache Software Foundation, http://www.apache.org/ |
|
|
|
Benchmarking 127.0.0.1 (be patient) |
|
Completed 100000 requests |
|
Completed 200000 requests |
|
Completed 300000 requests |
|
Completed 400000 requests |
|
Completed 500000 requests |
|
Completed 600000 requests |
|
Completed 700000 requests |
|
Completed 800000 requests |
|
Completed 900000 requests |
|
Completed 1000000 requests |
|
Finished 1000000 requests |
|
|
|
|
|
Server Software: Jetty(9.2.9.v20150224) |
|
Server Hostname: 127.0.0.1 |
|
Server Port: 17474 |
|
|
|
Document Path: /db/data/transaction/commit |
|
Document Length: 50 bytes |
|
|
|
Concurrency Level: 24 |
|
Time taken for tests: 37.839 seconds |
|
Complete requests: 1000000 |
|
Failed requests: 0 |
|
Keep-Alive requests: 1000000 |
|
Total transferred: 246000000 bytes |
|
Total body sent: 275000000 |
|
HTML transferred: 50000000 bytes |
|
Requests per second: 26427.87 [#/sec] (mean) |
|
Time per request: 0.908 [ms] (mean) |
|
Time per request: 0.038 [ms] (mean, across all concurrent requests) |
|
Transfer rate: 6348.88 [Kbytes/sec] received |
|
7097.33 kb/s sent |
|
13446.21 kb/s total |
|
|
|
Connection Times (ms) |
|
min mean[+/-sd] median max |
|
Connect: 0 0 0.0 0 0 |
|
Processing: 0 1 2.6 1 886 |
|
Waiting: 0 1 2.6 1 886 |
|
Total: 0 1 2.6 1 887 |
|
|
|
Percentage of the requests served within a certain time (ms) |
|
50% 1 |
|
66% 1 |
|
75% 1 |
|
80% 1 |
|
90% 1 |
|
95% 1 |
|
98% 2 |
|
99% 3 |
|
100% 887 (longest request) |
|
|
|
|
|
|
|
|
|
{"statements":[{"statement":"FOREACH (r in range(1,100) | CREATE (_0 {type:'Bike'}), (_0)-[:REL]->(_0))"}]} |
|
100000 x 100 rel + node -> 10M in 20s, 5k r/s |
|
|
|
sh _run_ab.sh 24 100000 create_100.json 17474 |
|
This is ApacheBench, Version 2.3 <$Revision: 1528965 $> |
|
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ |
|
Licensed to The Apache Software Foundation, http://www.apache.org/ |
|
|
|
Benchmarking 127.0.0.1 (be patient) |
|
Completed 10000 requests |
|
Completed 20000 requests |
|
Completed 30000 requests |
|
Completed 40000 requests |
|
Completed 50000 requests |
|
Completed 60000 requests |
|
Completed 70000 requests |
|
Completed 80000 requests |
|
Completed 90000 requests |
|
Completed 100000 requests |
|
Finished 100000 requests |
|
|
|
|
|
Server Software: Jetty(9.2.9.v20150224) |
|
Server Hostname: 127.0.0.1 |
|
Server Port: 17474 |
|
|
|
Document Path: /db/data/transaction/commit |
|
Document Length: 50 bytes |
|
|
|
Concurrency Level: 24 |
|
Time taken for tests: 19.933 seconds |
|
Complete requests: 100000 |
|
Failed requests: 0 |
|
Keep-Alive requests: 100000 |
|
Total transferred: 24600000 bytes |
|
Total body sent: 30600000 |
|
HTML transferred: 5000000 bytes |
|
Requests per second: 5016.86 [#/sec] (mean) |
|
Time per request: 4.784 [ms] (mean) |
|
Time per request: 0.199 [ms] (mean, across all concurrent requests) |
|
Transfer rate: 1205.22 [Kbytes/sec] received |
|
1499.18 kb/s sent |
|
2704.40 kb/s total |
|
|
|
Connection Times (ms) |
|
min mean[+/-sd] median max |
|
Connect: 0 0 0.0 0 1 |
|
Processing: 1 5 3.4 4 193 |
|
Waiting: 1 5 3.4 4 193 |
|
Total: 1 5 3.4 4 194 |
|
|
|
Percentage of the requests served within a certain time (ms) |
|
50% 4 |
|
66% 5 |
|
75% 6 |
|
80% 6 |
|
90% 7 |
|
95% 8 |
|
98% 10 |
|
99% 13 |
|
100% 194 (longest request) |
|
|
|
|
|
{"statements":[{"statement":"MATCH (n:Tag) WHERE n.tagId = 'neo4j' return n"}]} |
|
|
|
1M lookups and return by id in 17s 57k r/s |
|
|
|
sh _run_ab.sh 24 1000000 simple_lookup_property.json 17474 |
|
This is ApacheBench, Version 2.3 <$Revision: 1528965 $> |
|
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ |
|
Licensed to The Apache Software Foundation, http://www.apache.org/ |
|
|
|
Benchmarking 127.0.0.1 (be patient) |
|
Completed 100000 requests |
|
Completed 200000 requests |
|
Completed 300000 requests |
|
Completed 400000 requests |
|
Completed 500000 requests |
|
Completed 600000 requests |
|
Completed 700000 requests |
|
Completed 800000 requests |
|
Completed 900000 requests |
|
Completed 1000000 requests |
|
Finished 1000000 requests |
|
|
|
|
|
Server Software: Jetty(9.2.9.v20150224) |
|
Server Hostname: 127.0.0.1 |
|
Server Port: 17474 |
|
|
|
Document Path: /db/data/transaction/commit |
|
Document Length: 53 bytes |
|
|
|
Concurrency Level: 24 |
|
Time taken for tests: 17.412 seconds |
|
Complete requests: 1000000 |
|
Failed requests: 0 |
|
Keep-Alive requests: 1000000 |
|
Total transferred: 249000000 bytes |
|
Total body sent: 277000000 |
|
HTML transferred: 53000000 bytes |
|
Requests per second: 57430.54 [#/sec] (mean) |
|
Time per request: 0.418 [ms] (mean) |
|
Time per request: 0.017 [ms] (mean, across all concurrent requests) |
|
Transfer rate: 13965.04 [Kbytes/sec] received |
|
15535.41 kb/s sent |
|
29500.46 kb/s total |
|
|
|
Connection Times (ms) |
|
min mean[+/-sd] median max |
|
Connect: 0 0 0.0 0 0 |
|
Processing: 0 0 0.7 0 24 |
|
Waiting: 0 0 0.7 0 24 |
|
Total: 0 0 0.7 0 24 |
|
|
|
Percentage of the requests served within a certain time (ms) |
|
50% 0 |
|
66% 0 |
|
75% 0 |
|
80% 0 |
|
90% 1 |
|
95% 1 |
|
98% 3 |
|
99% 4 |
|
100% 24 (longest request) |
|
|
|
{"statements":[{"statement":"MATCH (n) WHERE id(n) = 10 return id(n)"}]} |
|
1M lookups by id in 22s, 43k r/s |
|
|
|
sh _run_ab.sh 24 1000000 simple_lookup.json 17474 |
|
This is ApacheBench, Version 2.3 <$Revision: 1528965 $> |
|
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ |
|
Licensed to The Apache Software Foundation, http://www.apache.org/ |
|
|
|
Benchmarking 127.0.0.1 (be patient) |
|
Completed 100000 requests |
|
Completed 200000 requests |
|
Completed 300000 requests |
|
Completed 400000 requests |
|
Completed 500000 requests |
|
Completed 600000 requests |
|
Completed 700000 requests |
|
Completed 800000 requests |
|
Completed 900000 requests |
|
Completed 1000000 requests |
|
Finished 1000000 requests |
|
|
|
|
|
Server Software: Jetty(9.2.9.v20150224) |
|
Server Hostname: 127.0.0.1 |
|
Server Port: 17474 |
|
|
|
Document Path: /db/data/transaction/commit |
|
Document Length: 83 bytes |
|
|
|
Concurrency Level: 24 |
|
Time taken for tests: 22.859 seconds |
|
Complete requests: 1000000 |
|
Failed requests: 0 |
|
Keep-Alive requests: 1000000 |
|
Total transferred: 279000000 bytes |
|
Total body sent: 270000000 |
|
HTML transferred: 83000000 bytes |
|
Requests per second: 43745.61 [#/sec] (mean) |
|
Time per request: 0.549 [ms] (mean) |
|
Time per request: 0.023 [ms] (mean, across all concurrent requests) |
|
Transfer rate: 11918.97 [Kbytes/sec] received |
|
11534.49 kb/s sent |
|
23453.46 kb/s total |
|
|
|
Connection Times (ms) |
|
min mean[+/-sd] median max |
|
Connect: 0 0 0.0 0 1 |
|
Processing: 0 1 1.0 0 84 |
|
Waiting: 0 1 1.0 0 84 |
|
Total: 0 1 1.0 0 84 |
|
|
|
Percentage of the requests served within a certain time (ms) |
|
50% 0 |
|
66% 0 |
|
75% 1 |
|
80% 1 |
|
90% 1 |
|
95% 1 |
|
98% 2 |
|
99% 4 |
|
100% 84 (longest request) |
|
|
|
|
|
{"statements":[{"statement":"cypher runtime=compiledExperimentalFeatureNotSupportedForProductionUse MATCH (n) WHERE id(n) = 10 return id(n)"}]} |
|
1M in 21s, 47k r/s |
|
|
|
sh _run_ab.sh 24 1000000 simple_lookup_compiled.json 17474 |
|
This is ApacheBench, Version 2.3 <$Revision: 1528965 $> |
|
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ |
|
Licensed to The Apache Software Foundation, http://www.apache.org/ |
|
|
|
Benchmarking 127.0.0.1 (be patient) |
|
Completed 100000 requests |
|
Completed 200000 requests |
|
Completed 300000 requests |
|
Completed 400000 requests |
|
Completed 500000 requests |
|
Completed 600000 requests |
|
Completed 700000 requests |
|
Completed 800000 requests |
|
Completed 900000 requests |
|
Completed 1000000 requests |
|
Finished 1000000 requests |
|
|
|
|
|
Server Software: Jetty(9.2.9.v20150224) |
|
Server Hostname: 127.0.0.1 |
|
Server Port: 17474 |
|
|
|
Document Path: /db/data/transaction/commit |
|
Document Length: 83 bytes |
|
|
|
Concurrency Level: 24 |
|
Time taken for tests: 21.236 seconds |
|
Complete requests: 1000000 |
|
Failed requests: 0 |
|
Keep-Alive requests: 1000000 |
|
Total transferred: 279000000 bytes |
|
Total body sent: 343000000 |
|
HTML transferred: 83000000 bytes |
|
Requests per second: 47090.12 [#/sec] (mean) |
|
Time per request: 0.510 [ms] (mean) |
|
Time per request: 0.021 [ms] (mean, across all concurrent requests) |
|
Transfer rate: 12830.22 [Kbytes/sec] received |
|
15773.35 kb/s sent |
|
28603.57 kb/s total |
|
|
|
Connection Times (ms) |
|
min mean[+/-sd] median max |
|
Connect: 0 0 0.0 0 1 |
|
Processing: 0 1 1.2 0 175 |
|
Waiting: 0 1 1.2 0 175 |
|
Total: 0 1 1.2 0 175 |
|
|
|
Percentage of the requests served within a certain time (ms) |
|
50% 0 |
|
66% 0 |
|
75% 1 |
|
80% 1 |
|
90% 1 |
|
95% 1 |
|
98% 2 |
|
99% 4 |
|
100% 175 (longest request) |
|
|
|
{"statements":[{"statement":"CREATE (_0 {type:'Bike'}), (_1 {type:'Wheel'}), (_2 {type:'Wheel'}), (_0)-[:WHEELS]->(_1), (_0)-[:WHEELS]->(_2) RETURN id(_0) AS _0, id(_1) AS _1, id(_2) AS _2","parameters":{},"resultDataContents":["row"]}]} |
|
create 2 nodes, 2 relationships, 2 properties |
|
1M in 47s, 21k r/s -> 80k records / s |
|
sh _run_ab.sh 24 1000000 create_plain.json 17474 |
|
This is ApacheBench, Version 2.3 <$Revision: 1528965 $> |
|
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ |
|
Licensed to The Apache Software Foundation, http://www.apache.org/ |
|
|
|
Benchmarking 127.0.0.1 (be patient) |
|
Completed 100000 requests |
|
Completed 200000 requests |
|
Completed 300000 requests |
|
Completed 400000 requests |
|
Completed 500000 requests |
|
Completed 600000 requests |
|
Completed 700000 requests |
|
Completed 800000 requests |
|
Completed 900000 requests |
|
Completed 1000000 requests |
|
Finished 1000000 requests |
|
|
|
|
|
Server Software: Jetty(9.2.9.v20150224) |
|
Server Hostname: 127.0.0.1 |
|
Server Port: 17474 |
|
|
|
Document Path: /db/data/transaction/commit |
|
Document Length: 124 bytes |
|
|
|
Concurrency Level: 24 |
|
Time taken for tests: 46.195 seconds |
|
Complete requests: 1000000 |
|
Failed requests: 0 |
|
Keep-Alive requests: 1000000 |
|
Total transferred: 321000000 bytes |
|
Total body sent: 438000000 |
|
HTML transferred: 124000000 bytes |
|
Requests per second: 21647.37 [#/sec] (mean) |
|
Time per request: 1.109 [ms] (mean) |
|
Time per request: 0.046 [ms] (mean, across all concurrent requests) |
|
Transfer rate: 6785.94 [Kbytes/sec] received |
|
9259.32 kb/s sent |
|
16045.27 kb/s total |
|
|
|
Connection Times (ms) |
|
min mean[+/-sd] median max |
|
Connect: 0 0 0.0 0 1 |
|
Processing: 0 1 1.0 1 185 |
|
Waiting: 0 1 1.0 1 185 |
|
Total: 0 1 1.0 1 186 |
|
|
|
Percentage of the requests served within a certain time (ms) |
|
50% 1 |
|
66% 1 |
|
75% 1 |
|
80% 1 |
|
90% 1 |
|
95% 2 |
|
98% 2 |
|
99% 2 |
|
100% 186 (longest request) |
|
|
|
|
|
|
|
{"statements":[{"statement":"CREATE (_0:`Bike`), (_1:`Wheel`), (_2:`Wheel`), (_0)-[:WHEELS]->(_1), (_0)-[:WHEELS]->(_2) RETURN id(_0) AS _0, id(_1) AS _1, id(_2) AS _2","parameters":{},"resultDataContents":["row"]}]}neo@neo:/ssd/ab/tes |
|
2 nodes with labels, 2 rels, 0 properties |
|
1M in 140s, 7k r/s |
|
|
|
sh _run_ab.sh 24 1000000 create_label.json 17474 |
|
This is ApacheBench, Version 2.3 <$Revision: 1528965 $> |
|
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ |
|
Licensed to The Apache Software Foundation, http://www.apache.org/ |
|
|
|
Benchmarking 127.0.0.1 (be patient) |
|
Completed 100000 requests |
|
Completed 200000 requests |
|
Completed 300000 requests |
|
Completed 400000 requests |
|
Completed 500000 requests |
|
Completed 600000 requests |
|
Completed 700000 requests |
|
Completed 800000 requests |
|
Completed 900000 requests |
|
Completed 1000000 requests |
|
Finished 1000000 requests |
|
|
|
|
|
Server Software: Jetty(9.2.9.v20150224) |
|
Server Hostname: 127.0.0.1 |
|
Server Port: 17474 |
|
|
|
Document Path: /db/data/transaction/commit |
|
Document Length: 124 bytes |
|
|
|
Concurrency Level: 24 |
|
Time taken for tests: 140.759 seconds |
|
Complete requests: 1000000 |
|
Failed requests: 0 |
|
Keep-Alive requests: 1000000 |
|
Total transferred: 321000000 bytes |
|
Total body sent: 416000000 |
|
HTML transferred: 124000000 bytes |
|
Requests per second: 7104.33 [#/sec] (mean) |
|
Time per request: 3.378 [ms] (mean) |
|
Time per request: 0.141 [ms] (mean, across all concurrent requests) |
|
Transfer rate: 2227.04 [Kbytes/sec] received |
|
2886.13 kb/s sent |
|
5113.18 kb/s total |
|
|
|
Connection Times (ms) |
|
min mean[+/-sd] median max |
|
Connect: 0 0 0.0 0 1 |
|
Processing: 2 3 1.5 3 183 |
|
Waiting: 1 3 1.5 3 183 |
|
Total: 2 3 1.5 3 184 |
|
|
|
Percentage of the requests served within a certain time (ms) |
|
50% 3 |
|
66% 4 |
|
75% 4 |
|
80% 4 |
|
90% 4 |
|
95% 5 |
|
98% 6 |
|
99% 7 |
|
100% 184 (longest request) |
|
|