ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
protocolversion - compression - gocqlversion
latencies in ms
https://github.com/apache/cassandra-gocql-driver/commit/adeb20468ea4edc292befc8de546a81950b5f7b4
3
4
Protocol V4, NO COMPRESSION
Cycles per Second: 17030.171
Cycles per Second: 16773.663
5
v4 - false - 1.7INSERTSELECTBASEBASETotal Errors: 0Total Errors: 0
6
p500.8310.829--
INSERT Operations: 40000000
INSERT Operations: 40000000
7
p901.1811.173--
Average Time: 0.926ms (926μs)
Average Time: 0.936ms (936μs)
8
p951.4931.472--
50th Percentile (Median): 0.831ms (831μs)
50th Percentile (Median): 0.847ms (847μs)
9
p993.3133.252--
90th Percentile: 1.181ms (1181μs)
90th Percentile: 1.198ms (1198μs)
10
ops17030.17117030.171--
95th Percentile: 1.493ms (1493μs)
95th Percentile: 1.474ms (1474μs)
11
99th Percentile: 3.313ms (3313μs)
99th Percentile: 3.232ms (3232μs)
12
Total Time: 37050807.003ms
Total Time: 37443670.406ms
13
v4 - false - 2.0INSERTSELECTINSERT vs baseSELECT vs base
SELECT Operations: 40000000
SELECT Operations: 40000000
14
p500.8470.8451.93%1.93%
Average Time: 0.915ms (915μs)
Average Time: 0.930ms (930μs)
15
p901.1981.1931.44%1.71%
50th Percentile (Median): 0.829ms (829μs)
50th Percentile (Median): 0.845ms (845μs)
16
p951.4741.473-1.27%0.07%
90th Percentile: 1.173ms (1173μs)
90th Percentile: 1.193ms (1193μs)
17
p993.2323.252-2.44%0.00%
95th Percentile: 1.472ms (1472μs)
95th Percentile: 1.473ms (1473μs)
18
ops16773.66316773.663-1.51%-1.51%
99th Percentile: 3.252ms (3252μs)
99th Percentile: 3.252ms (3252μs)
19
Total Time: 36619110.288ms
Total Time: 37203248.645ms
20
21
22
Protocol V4 vs V5, NO COMPRESSION
Cycles per Second: 17625.284
Cycles per Second: 17333.350
23
v4 - false - 1.7INSERTSELECTBASEBASETotal Errors: 0Total Errors: 0
24
p500.7810.776--
INSERT Operations: 40000000
INSERT Operations: 40000000
25
p901.1791.166--
Average Time: 0.895ms (895μs)
Average Time: 0.905ms (905μs)
26
p951.5571.526--
50th Percentile (Median): 0.781ms (781μs)
50th Percentile (Median): 0.783ms (783μs)
27
p993.4163.358--
90th Percentile: 1.179ms (1179μs)
90th Percentile: 1.224ms (1224μs)
28
ops17625.28417625.284--
95th Percentile: 1.557ms (1557μs)
95th Percentile: 1.640ms (1640μs)
29
99th Percentile: 3.416ms (3416μs)
99th Percentile: 3.413ms (3413μs)
30
Total Time: 35818216.164ms
Total Time: 36201594.876ms
31
v5 - false - 2.0INSERTSELECTINSERT vs baseSELECT vs base
SELECT Operations: 40000000
SELECT Operations: 40000000
32
p500.7830.7790.26%0.39%
Average Time: 0.881ms (881μs)
Average Time: 0.896ms (896μs)
33
p901.2241.2153.82%4.20%
50th Percentile (Median): 0.776ms (776μs)
50th Percentile (Median): 0.779ms (779μs)
34
p951.641.6465.33%7.86%
90th Percentile: 1.166ms (1166μs)
90th Percentile: 1.215ms (1215μs)
35
p993.4133.422-0.09%1.91%
95th Percentile: 1.526ms (1526μs)
95th Percentile: 1.646ms (1646μs)
36
ops17333.3517333.35-1.66%-1.66%
99th Percentile: 3.358ms (3358μs)
99th Percentile: 3.422ms (3422μs)
37
There is no protocol v5 support in gocql v1 so there's no direct comparison for protocol v5 performance
Total Time: 35239440.474ms
Total Time: 35844503.607ms
38
39
40
Protocol V4, WITH COMPRESSION
Cycles per Second: 9401.180
Cycles per Second: 9305.154
41
v4 - true - 1.7INSERTSELECTBASEBASETotal Errors: 0Total Errors: 0
42
p501.3741.35--
INSERT Operations: 40000000
INSERT Operations: 40000000
43
p902.6792.664--
Average Time: 1.673ms (1673μs)
Average Time: 1.664ms (1664μs)
44
p953.3543.319--
50th Percentile (Median): 1.374ms (1374μs)
50th Percentile (Median): 1.371ms (1371μs)
45
p995.2935.232--
90th Percentile: 2.679ms (2679μs)
90th Percentile: 2.673ms (2673μs)
46
ops9401.189401.18--
95th Percentile: 3.354ms (3354μs)
95th Percentile: 3.332ms (3332μs)
47
99th Percentile: 5.293ms (5293μs)
99th Percentile: 5.215ms (5215μs)
48
Total Time: 66926709.788ms
Total Time: 66543189.773ms
49
v4 - true - 2.0INSERTSELECTINSERT vs baseSELECT vs base
SELECT Operations: 40000000
SELECT Operations: 40000000
50
p501.3711.358-0.22%0.59%
Average Time: 1.652ms (1652μs)
Average Time: 1.668ms (1668μs)
51
p902.6732.711-0.22%1.76%
50th Percentile (Median): 1.350ms (1350μs)
50th Percentile (Median): 1.358ms (1358μs)
52
p953.3323.391-0.66%2.17%
90th Percentile: 2.664ms (2664μs)
90th Percentile: 2.711ms (2711μs)
53
p995.2155.322-1.47%1.72%
95th Percentile: 3.319ms (3319μs)
95th Percentile: 3.391ms (3391μs)
54
ops9305.1549305.154-1.02%-1.02%
99th Percentile: 5.232ms (5232μs)
99th Percentile: 5.322ms (5322μs)
55
Total Time: 66060053.281ms
Total Time: 66722328.476ms
56
57
58
Protocol V4 vs V5, WITH COMPRESSION
Cycles per Second: 9244.020
Cycles per Second: 9126.125
59
v4 - true - v1INSERTSELECTBASEBASETotal Errors: 0Total Errors: 0
60
p501.4041.377--
INSERT Operations: 40000000
INSERT Operations: 40000000
61
p902.7162.698--
Average Time: 1.704ms (1704μs)
Average Time: 1.701ms (1701μs)
62
p953.4063.366--
50th Percentile (Median): 1.404ms (1404μs)
50th Percentile (Median): 1.403ms (1403μs)
63
p995.365.313--
90th Percentile: 2.716ms (2716μs)
90th Percentile: 2.732ms (2732μs)
64
ops9244.029244.02--
95th Percentile: 3.406ms (3406μs)
95th Percentile: 3.403ms (3403μs)
65
99th Percentile: 5.360ms (5360μs)
99th Percentile: 5.321ms (5321μs)
66
Total Time: 68153767.511ms
Total Time: 68040413.957ms
67
v5 - true - v2INSERTSELECTINSERT vs baseSELECT vs base
SELECT Operations: 40000000
SELECT Operations: 40000000
68
p501.4031.38-0.07%0.22%
Average Time: 1.679ms (1679μs)
Average Time: 1.698ms (1698μs)
69
p902.7322.7610.59%2.34%
50th Percentile (Median): 1.377ms (1377μs)
50th Percentile (Median): 1.380ms (1380μs)
70
p953.4033.447-0.09%2.41%
90th Percentile: 2.698ms (2698μs)
90th Percentile: 2.761ms (2761μs)
71
p995.3215.404-0.73%1.71%
95th Percentile: 3.366ms (3366μs)
95th Percentile: 3.447ms (3447μs)
72
ops9126.1259126.125-1.28%-1.28%
99th Percentile: 5.313ms (5313μs)
99th Percentile: 5.404ms (5404μs)
73
There is no protocol v5 support in gocql v1 so there's no direct comparison for protocol v5 performance
Total Time: 67170056.443ms
Total Time: 67912594.598ms
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100