-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathresult.txt
More file actions
76 lines (67 loc) · 3.17 KB
/
result.txt
File metadata and controls
76 lines (67 loc) · 3.17 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
====================================================================================================
LADYBUG WRITE PERFORMANCE BENCHMARK
====================================================================================================
Configuration:
Number of rows: 100,000
Batch size: 1,000
Number of threads: 4
Database path: /tmp/ladybug_write_benchmark.lbug
System memory: 21.46 GB
Available CPUs: 12
====================================================================================================
Benchmarking NODE table INSERT (100,000 rows)...
Inserted 1,000 / 100,000 rows...
Inserted 11,000 / 100,000 rows...
Inserted 21,000 / 100,000 rows...
Inserted 31,000 / 100,000 rows...
Inserted 41,000 / 100,000 rows...
Inserted 51,000 / 100,000 rows...
Inserted 61,000 / 100,000 rows...
Inserted 71,000 / 100,000 rows...
Inserted 81,000 / 100,000 rows...
Inserted 91,000 / 100,000 rows...
✓ Completed in 4362.55 ms
✓ Throughput: 22922.38 rows/s
Benchmarking NODE table PARQUET bulk load (100,000 rows)...
Generating Parquet file...
✓ Completed in 1769.03 ms
✓ Throughput: 56528.28 rows/s
Benchmarking REL table INSERT (100,000 relationships)...
Creating 10,000 source and target nodes...
Inserted 1,000 / 100,000 relationships...
Inserted 11,000 / 100,000 relationships...
Inserted 21,000 / 100,000 relationships...
Inserted 31,000 / 100,000 relationships...
Inserted 41,000 / 100,000 relationships...
Inserted 51,000 / 100,000 relationships...
Inserted 61,000 / 100,000 relationships...
Inserted 71,000 / 100,000 relationships...
Inserted 81,000 / 100,000 relationships...
Inserted 91,000 / 100,000 relationships...
✓ Completed in 58472.48 ms
✓ Throughput: 1710.21 rows/s
Benchmarking REL table PARQUET bulk load (100,000 relationships)...
Creating 10,000 source and target nodes...
Generating Parquet file...
✓ Completed in 4551.42 ms
✓ Throughput: 21971.15 rows/s
====================================================================================================
BENCHMARK RESULTS
====================================================================================================
Test Name Type Rows Time (ms) Throughput (rows/s) Memory (MB)
----------------------------------------------------------------------------------------------------
Node INSERT (CREATE statements) NODE 100,000 4,362.55 22,922.38 279.04
Node COPY FROM Parquet NODE 100,000 1,769.03 56,528.28 33.93
Rel INSERT (CREATE statements) REL 100,000 58,472.48 1,710.21 15.15
Rel COPY FROM Parquet REL 100,000 4,551.42 21,971.15 23.62
====================================================================================================
PERFORMANCE COMPARISON:
------------------------------------------------------------
NODE Tables:
INSERT: 22,922.38 rows/s
PARQUET: 56,528.28 rows/s
Speedup: 2.47x (Parquet is 2.47x faster)
REL Tables:
INSERT: 1,710.21 rows/s
PARQUET: 21,971.15 rows/s
Speedup: 12.85x (Parquet is 12.85x faster)