Benchmark for Shared Tables

The shared table benchmarks the default out-of-the-box setup where all of the modules utilize the same database table with all of the values JSON encoded into a single column. This setup is intended for generic and low volume modules since it’s easier to setup and requires less maintenance.

This document should be used as a base to figure out what setup would work best for you. You can use the raw numbers of different scenarios to deduct your own conclusions on how well a specific setup would pan out for your use case.
Testing notes:

  • All times are in MS with networking overhead excluded (the scripts were ran directly on the host server).

  • Each scenario used a dedicated DB table which was configured as the standard compose_records one. The primary reason is consistent repeatability. Namespace and module identifiers are indexed so the overhead is negligible.

  • Records were created from a pre-defined dataset with randomly generated data using faker.js.

  • Benchmarks were ran on a dedicated cloud instance with minimal background processes.

  • The tests use Postgres as the database.

Testing observations:

  • We observed some random spikes under the max time which we couldn’t quite explain. Our guess would indicate some background system task or potential throttling. Ideally, in future tests, such anomalies would be excluded or better handled.

Future plans:

  • Increase the amount of data points to better indicate the trend.

  • Include some projections to indicate how it would behave on larger datasets.

  • Provide memory profiling to indicate consumption and better suggest recommended system specs.

CRUD Operation: Create

The scenario benchmarks insertion times into an already existing module with N pre-created records (where N is the record count in the following tables).

This benchmark inserts a single record into the module with N records pre-created before the scenario.

Number of Fields 1

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 103, 98, 103, 104, 103, 102, 107, 103, 102, 100 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 112, 169, 119, 115, 116, 117, 117, 126, 152, 151 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 106.8, 116.5, 108.8, 109.8, 109.7, 108.8, 111.5, 111.3, 114
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

103

112

106.8

1

1

1

1

200000

98

169

116.5

1.05

0.66

0.92

1

300000

103

119

108.8

0.95

1.42

1.07

1

400000

104

115

109.8

0.99

1.03

0.99

1

500000

103

116

109.7

1.01

0.99

1

1

600000

102

117

108.8

1.01

0.99

1.01

1

700000

107

117

111.5

0.95

1

0.98

1

800000

103

126

111.3

1.04

0.93

1

1

900000

102

152

114.7

1.01

0.83

0.97

1

1000000

100

151

113

1.02

1.01

1.02

Number of Fields 10

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 104, 103, 106, 103, 99, 105, 107, 103, 102, 102 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 115, 126, 139, 127, 124, 115, 139, 173, 144, 134 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 110.1, 112, 116.5, 111, 108.7, 109.5, 115, 115.8, 112.9, 111
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

104

115

110.1

1

1

1

10

200000

103

126

112

1.01

0.91

0.98

10

300000

106

139

116.5

0.97

0.91

0.96

10

400000

103

127

111

1.03

1.09

1.05

10

500000

99

124

108.7

1.04

1.02

1.02

10

600000

105

115

109.5

0.94

1.08

0.99

10

700000

107

139

115

0.98

0.83

0.95

10

800000

103

173

115.8

1.04

0.8

0.99

10

900000

102

144

112.9

1.01

1.2

1.03

10

1000000

102

134

111.2

1

1.07

1.02

Number of Fields 50

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 110, 105, 112, 105, 105, 109, 105, 108, 107, 109 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 180, 198, 169, 210, 134, 150, 158, 148, 178, 179 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 132.6, 123.7, 126.6, 124.4, 117.2, 122.7, 119.5, 121.2, 127.8, 126
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

110

180

132.6

1

1

1

50

200000

105

198

123.7

1.05

0.91

1.07

50

300000

112

169

126.6

0.94

1.17

0.98

50

400000

105

210

124.4

1.07

0.8

1.02

50

500000

105

134

117.2

1

1.57

1.06

50

600000

109

150

122.7

0.96

0.89

0.96

50

700000

105

158

119.5

1.04

0.95

1.03

50

800000

108

148

121.2

0.97

1.07

0.99

50

900000

107

178

127.8

1.01

0.83

0.95

50

1000000

109

179

126.1

0.98

0.99

1.01

Number of Fields 100

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 116, 117, 114, 116, 119, 119, 118, 116, 116, 120 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 136, 163, 131, 153, 164, 135, 134, 157, 128, 190 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 124.5, 127.6, 122.6, 128.4, 128.1, 124.7, 124.4, 130.8, 122
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

116

136

124.5

1

1

1

100

200000

117

163

127.6

0.99

0.83

0.98

100

300000

114

131

122.6

1.03

1.24

1.04

100

400000

116

153

128.4

0.98

0.86

0.95

100

500000

119

164

128.1

0.97

0.93

1

100

600000

119

135

124.7

1

1.21

1.03

100

700000

118

134

124.4

1.01

1.01

1

100

800000

116

157

130.8

1.02

0.85

0.95

100

900000

116

128

122.3

1

1.23

1.07

100

1000000

120

190

133

0.97

0.67

0.92

CRUD Operation: Lookup

The scenario benchmarks lookup times into an already existing module with N pre-created records (where N is the record count in the following tables).

This benchmark looks up a single record from the module with N records pre-created before the scenario.

Number of Fields 1

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 112, 125, 133, 162, 141, 144, 150, 156, 171, 197 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 140, 176, 208, 219, 158, 160, 178, 181, 314, 355 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 118.4, 144.8, 172.2, 179.8, 149.2, 151.5, 166.2, 165.6, 208.9, 261
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

112

140

118.4

1

1

1

1

200000

125

176

144.8

0.9

0.8

0.82

1

300000

133

208

172.2

0.94

0.85

0.84

1

400000

162

219

179.8

0.82

0.95

0.96

1

500000

141

158

149.2

1.15

1.39

1.21

1

600000

144

160

151.5

0.98

0.99

0.98

1

700000

150

178

166.2

0.96

0.9

0.91

1

800000

156

181

165.6

0.96

0.98

1

1

900000

171

314

208.9

0.91

0.58

0.79

1

1000000

197

355

261.1

0.87

0.88

0.8

Number of Fields 10

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 127, 152, 195, 191, 212, 206, 247, 324, 339, 401 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 168, 289, 411, 476, 413, 368, 540, 447, 714, 679 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 143.4, 209.3, 263.4, 292, 276.1, 296.1, 361.1, 382.5, 476.3, 547
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

127

168

143.4

1

1

1

10

200000

152

289

209.3

0.84

0.58

0.69

10

300000

195

411

263.4

0.78

0.7

0.79

10

400000

191

476

292

1.02

0.86

0.9

10

500000

212

413

276.1

0.9

1.15

1.06

10

600000

206

368

296.1

1.03

1.12

0.93

10

700000

247

540

361.1

0.83

0.68

0.82

10

800000

324

447

382.5

0.76

1.21

0.94

10

900000

339

714

476.3

0.96

0.63

0.8

10

1000000

401

679

547.6

0.85

1.05

0.87

Number of Fields 50

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 187, 266, 432, 479, 486, 975, 106, 110, 110, 662 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 510, 1303, 701, 1178, 801, 1656, 2437, 2000, 2878, 3179 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 248.3, 514, 563.4, 635.7, 675.3, 1405.5, 801.8, 1276.6, 1649.2, 1893
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

187

510

248.3

1

1

1

50

200000

266

1303

514

0.7

0.39

0.48

50

300000

432

701

563.4

0.62

1.86

0.91

50

400000

479

1178

635.7

0.9

0.6

0.89

50

500000

486

801

675.3

0.99

1.47

0.94

50

600000

975

1656

1405.5

0.5

0.48

0.48

50

700000

106

2437

801.8

9.2

0.68

1.75

50

800000

110

2000

1276.6

0.96

1.22

0.63

50

900000

110

2878

1649.2

1

0.69

0.77

50

1000000

662

3179

1893.2

0.17

0.91

0.87

Number of Fields 100

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 119, 136, 155, 163, 167, 191, 181, 204, 191, 218 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 167, 162, 180, 217, 317, 441, 373, 374, 334, 473 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 131.7, 147.5, 163.6, 182.4, 215.8, 236.9, 230.7, 293.9, 238, 318
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

119

167

131.7

1

1

1

100

200000

136

162

147.5

0.88

1.03

0.89

100

300000

155

180

163.6

0.88

0.9

0.9

100

400000

163

217

182.4

0.95

0.83

0.9

100

500000

167

317

215.8

0.98

0.68

0.85

100

600000

191

441

236.9

0.87

0.72

0.91

100

700000

181

373

230.7

1.06

1.18

1.03

100

800000

204

374

293.9

0.89

1

0.78

100

900000

191

334

238

1.07

1.12

1.23

100

1000000

218

473

318.1

0.88

0.71

0.75

CRUD Operation: Update

The scenario benchmarks update times into an already existing module with N pre-created records (where N is the record count in the following tables).

This benchmark updates a single record from the module with N records pre-created before the scenario.

Number of Fields 1

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 127, 161, 172, 205, 200, 214, 240, 272, 293, 380 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 147, 238, 271, 307, 233, 255, 328, 344, 439, 584 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 137.6, 195.1, 230.7, 261.4, 215.7, 233.6, 276.7, 302.5, 361.1, 473
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

127

147

137.6

1

1

1

1

200000

161

238

195.1

0.79

0.62

0.71

1

300000

172

271

230.7

0.94

0.88

0.85

1

400000

205

307

261.4

0.84

0.88

0.88

1

500000

200

233

215.7

1.02

1.32

1.21

1

600000

214

255

233.6

0.93

0.91

0.92

1

700000

240

328

276.7

0.89

0.78

0.84

1

800000

272

344

302.5

0.88

0.95

0.91

1

900000

293

439

361.1

0.93

0.78

0.84

1

1000000

380

584

473.1

0.77

0.75

0.76

Number of Fields 10

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 165, 258, 354, 322, 422, 466, 509, 501, 631, 729 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 239, 484, 627, 528, 683, 717, 820, 753, 1177, 1037 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 188.4, 344.6, 429, 433.1, 534.4, 529.4, 631.2, 634.1, 901.4, 897
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

165

239

188.4

1

1

1

10

200000

258

484

344.6

0.64

0.49

0.55

10

300000

354

627

429

0.73

0.77

0.8

10

400000

322

528

433.1

1.1

1.19

0.99

10

500000

422

683

534.4

0.76

0.77

0.81

10

600000

466

717

529.4

0.91

0.95

1.01

10

700000

509

820

631.2

0.92

0.87

0.84

10

800000

501

753

634.1

1.02

1.09

1

10

900000

631

1177

901.4

0.79

0.64

0.7

10

1000000

729

1037

897.1

0.87

1.14

1

Number of Fields 50

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 286, 457, 542, 936, 751, 1984, 2154, 2245, 2448, 3636 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 435, 957, 1025, 1372, 1535, 3070, 4020, 3810, 5539, 6192 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 357.1, 721.5, 824.3, 1133.2, 1106.7, 2580.3, 2785.5, 2898.4, 3790.6, 4888
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

286

435

357.1

1

1

1

50

200000

457

957

721.5

0.63

0.45

0.49

50

300000

542

1025

824.3

0.84

0.93

0.88

50

400000

936

1372

1133.2

0.58

0.75

0.73

50

500000

751

1535

1106.7

1.25

0.89

1.02

50

600000

1984

3070

2580.3

0.38

0.5

0.43

50

700000

2154

4020

2785.5

0.92

0.76

0.93

50

800000

2245

3810

2898.4

0.96

1.06

0.96

50

900000

2448

5539

3790.6

0.92

0.69

0.76

50

1000000

3636

6192

4888.1

0.67

0.89

0.78

Number of Fields 100

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 141, 201, 222, 225, 286, 294, 309, 336, 357, 356 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 182, 258, 247, 368, 350, 471, 412, 539, 513, 649 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 161.6, 220.4, 230.5, 275, 320.9, 357.8, 369.9, 428.1, 413.3, 494
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

141

182

161.6

1

1

1

100

200000

201

258

220.4

0.7

0.71

0.73

100

300000

222

247

230.5

0.91

1.04

0.96

100

400000

225

368

275

0.99

0.67

0.84

100

500000

286

350

320.9

0.79

1.05

0.86

100

600000

294

471

357.8

0.97

0.74

0.9

100

700000

309

412

369.9

0.95

1.14

0.97

100

800000

336

539

428.1

0.92

0.76

0.86

100

900000

357

513

413.3

0.94

1.05

1.04

100

1000000

356

649

494.6

1

0.79

0.84

CRUD Operation: Delete

The scenario benchmarks delete times into an already existing module with N pre-created records (where N is the record count in the following tables).

This benchmark deletes a single record from the module with N records pre-created before the scenario.

Number of Fields 1

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 121, 149, 176, 194, 192, 211, 227, 272, 296, 306 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 143, 220, 430, 334, 227, 341, 350, 306, 408, 502 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 133, 194.8, 247.3, 259.5, 209.5, 241.6, 272.4, 287.1, 338.4, 409
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

121

143

133

1

1

1

1

200000

149

220

194.8

0.81

0.65

0.68

1

300000

176

430

247.3

0.85

0.51

0.79

1

400000

194

334

259.5

0.91

1.29

0.95

1

500000

192

227

209.5

1.01

1.47

1.24

1

600000

211

341

241.6

0.91

0.67

0.87

1

700000

227

350

272.4

0.93

0.97

0.89

1

800000

272

306

287.1

0.83

1.14

0.95

1

900000

296

408

338.4

0.92

0.75

0.85

1

1000000

306

502

409.8

0.97

0.81

0.83

Number of Fields 10

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 156, 254, 345, 276, 320, 344, 462, 552, 627, 703 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 227, 458, 526, 637, 627, 575, 819, 833, 1384, 1391 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 180.6, 330.1, 433.5, 454.3, 503.2, 466.5, 639.6, 685.1, 884.1, 1016
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

156

227

180.6

1

1

1

10

200000

254

458

330.1

0.61

0.5

0.55

10

300000

345

526

433.5

0.74

0.87

0.76

10

400000

276

637

454.3

1.25

0.83

0.95

10

500000

320

627

503.2

0.86

1.02

0.9

10

600000

344

575

466.5

0.93

1.09

1.08

10

700000

462

819

639.6

0.74

0.7

0.73

10

800000

552

833

685.1

0.84

0.98

0.93

10

900000

627

1384

884.1

0.88

0.6

0.77

10

1000000

703

1391

1016.9

0.89

0.99

0.87

Number of Fields 50

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 278, 453, 793, 784, 1024, 1944, 2113, 2274, 2663, 3686 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 432, 980, 1003, 1229, 1325, 2998, 4556, 4684, 5121, 5732 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 332.8, 740.6, 882.1, 1061, 1161.6, 2586.5, 2896.6, 3228.6, 3662.5, 4647
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

278

432

332.8

1

1

1

50

200000

453

980

740.6

0.61

0.44

0.45

50

300000

793

1003

882.1

0.57

0.98

0.84

50

400000

784

1229

1061

1.01

0.82

0.83

50

500000

1024

1325

1161.6

0.77

0.93

0.91

50

600000

1944

2998

2586.5

0.53

0.44

0.45

50

700000

2113

4556

2896.6

0.92

0.66

0.89

50

800000

2274

4684

3228.6

0.93

0.97

0.9

50

900000

2663

5121

3662.5

0.85

0.91

0.88

50

1000000

3686

5732

4647.5

0.72

0.89

0.79

Number of Fields 100

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 134, 168, 193, 226, 270, 231, 311, 309, 344, 283 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 167, 226, 238, 311, 398, 463, 427, 648, 462, 682 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 147.7, 200.6, 213.2, 255.5, 319.7, 366, 352.6, 451.8, 392.8, 454
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

134

167

147.7

1

1

1

100

200000

168

226

200.6

0.8

0.74

0.74

100

300000

193

238

213.2

0.87

0.95

0.94

100

400000

226

311

255.5

0.85

0.77

0.83

100

500000

270

398

319.7

0.84

0.78

0.8

100

600000

231

463

366

1.17

0.86

0.87

100

700000

311

427

352.6

0.74

1.08

1.04

100

800000

309

648

451.8

1.01

0.66

0.78

100

900000

344

462

392.8

0.9

1.4

1.15

100

1000000

283

682

454.4

1.22

0.68

0.86

Filtering Records: Searching

The scenario benchmarks fetching the first page of records when providing a filter. The page size is 20 records.

The scenario excludes both the total record count and the complete paging navigation.

Number of Fields 1

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 147, 167, 206, 268, 259, 257, 347, 425, 467, 478 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 197, 305, 531, 397, 560, 442, 842, 780, 855, 1090 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 171.1, 199.4, 317.6, 330.6, 333.2, 362.4, 483.5, 561.5, 605.9, 657
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

147

197

171.1

1

1

1

1

200000

167

305

199.4

0.88

0.65

0.86

1

300000

206

531

317.6

0.81

0.57

0.63

1

400000

268

397

330.6

0.77

1.34

0.96

1

500000

259

560

333.2

1.03

0.71

0.99

1

600000

257

442

362.4

1.01

1.27

0.92

1

700000

347

842

483.5

0.74

0.52

0.75

1

800000

425

780

561.5

0.82

1.08

0.86

1

900000

467

855

605.9

0.91

0.91

0.93

1

1000000

478

1090

657.6

0.98

0.78

0.92

Number of Fields 10

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 249, 282, 483, 518, 557, 720, 664, 819, 1010, 1036 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 310, 576, 1006, 781, 994, 1341, 1918, 2076, 2087, 2511 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 272.2, 408.9, 679.9, 630.5, 756.5, 869.6, 1088.3, 1362.1, 1261
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

249

310

272.2

1

1

1

10

200000

282

576

408.9

0.88

0.54

0.67

10

300000

483

1006

679.9

0.58

0.57

0.6

10

400000

518

781

630.5

0.93

1.29

1.08

10

500000

557

994

756.5

0.93

0.79

0.83

10

600000

720

1341

869.6

0.77

0.74

0.87

10

700000

664

1918

1088.3

1.08

0.7

0.8

10

800000

819

2076

1362.1

0.81

0.92

0.8

10

900000

1010

2087

1261.2

0.81

0.99

1.08

10

1000000

1036

2511

1337

0.97

0.83

0.94

Number of Fields 50

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 539, 1309, 1763, 2050, 2564, 2961, 3052, 4244, 4442, 5156 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 1049, 2806, 2217, 5836, 4201, 9138, 5668, 11147, 7382, 15973 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 744.2, 2138.1, 2008.2, 3014, 3093.9, 5019.7, 3909.6, 5832
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

539

1049

744.2

1

1

1

50

200000

1309

2806

2138.1

0.41

0.37

0.35

50

300000

1763

2217

2008.2

0.74

1.27

1.06

50

400000

2050

5836

3014

0.86

0.38

0.67

50

500000

2564

4201

3093.9

0.8

1.39

0.97

50

600000

2961

9138

5019.7

0.87

0.46

0.62

50

700000

3052

5668

3909.6

0.97

1.61

1.28

50

800000

4244

11147

5832.7

0.72

0.51

0.67

50

900000

4442

7382

5249

0.96

1.51

1.11

50

1000000

5156

15973

6875

0.86

0.46

0.76

Number of Fields 100

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 4631, 4454, 9425, 12032, 22679, 56534, 20436, 37712, 26639, 27680 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 11722, 11748, 16404, 22468, 34568, 62023, 35426, 48479, 46577, 37706 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 6098.2, 6394.4, 10905.3, 14475.3, 28872.5, 58330.2, 23787.1, 44679.9, 36614.2, 29703
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

4631

11722

6098.2

1

1

1

100

200000

4454

11748

6394.4

1.04

1

0.95

100

300000

9425

16404

10905.3

0.47

0.72

0.59

100

400000

12032

22468

14475.3

0.78

0.73

0.75

100

500000

22679

34568

28872.5

0.53

0.65

0.5

100

600000

56534

62023

58330.2

0.4

0.56

0.49

100

700000

20436

35426

23787.1

2.77

1.75

2.45

100

800000

37712

48479

44679.9

0.54

0.73

0.53

100

900000

26639

46577

36614.2

1.42

1.04

1.22

100

1000000

27680

37706

29703.6

0.96

1.24

1.23

Filtering and Sorting Records: Searching

The scenario benchmarks fetching the first page of records when providing a filter and a sort. The page size is 20 records.

The scenario excludes both the total record count and the complete paging navigation.

Number of Fields 1

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 156, 166, 184, 237, 270, 290, 335, 373, 444, 444 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 229, 303, 387, 504, 545, 643, 449, 528, 985, 1087 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 179.6, 205, 276.3, 315.1, 377.9, 372, 406.5, 427.2, 679.9, 694
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

156

229

179.6

1

1

1

1

200000

166

303

205

0.94

0.76

0.88

1

300000

184

387

276.3

0.9

0.78

0.74

1

400000

237

504

315.1

0.78

0.77

0.88

1

500000

270

545

377.9

0.88

0.92

0.83

1

600000

290

643

372

0.93

0.85

1.02

1

700000

335

449

406.5

0.87

1.43

0.92

1

800000

373

528

427.2

0.9

0.85

0.95

1

900000

444

985

679.9

0.84

0.54

0.63

1

1000000

444

1087

694.8

1

0.91

0.98

Number of Fields 10

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 270, 500, 716, 860, 857, 1090, 1165, 1472, 1728, 2153 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 538, 1303, 1781, 1201, 1302, 1620, 2813, 1662, 2660, 5705 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 361.4, 874.9, 1070.3, 980.8, 1086.7, 1462.4, 1563.4, 1541.8, 1946, 3652
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

270

538

361.4

1

1

1

10

200000

500

1303

874.9

0.54

0.41

0.41

10

300000

716

1781

1070.3

0.7

0.73

0.82

10

400000

860

1201

980.8

0.83

1.48

1.09

10

500000

857

1302

1086.7

1

0.92

0.9

10

600000

1090

1620

1462.4

0.79

0.8

0.74

10

700000

1165

2813

1563.4

0.94

0.58

0.94

10

800000

1472

1662

1541.8

0.79

1.69

1.01

10

900000

1728

2660

1946

0.85

0.62

0.79

10

1000000

2153

5705

3652.9

0.8

0.47

0.53

Number of Fields 50

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 633, 1914, 2330, 3582, 3562, 3965, 4983, 5733, 7575, 9320 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 1001, 5230, 3879, 9070, 4493, 4953, 7320, 8707, 9002, 26861 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 876.7, 3309.7, 3036.5, 4592.5, 3927.2, 4297.1, 5548.8, 6967.8, 8258.5, 17746
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

633

1001

876.7

1

1

1

50

200000

1914

5230

3309.7

0.33

0.19

0.26

50

300000

2330

3879

3036.5

0.82

1.35

1.09

50

400000

3582

9070

4592.5

0.65

0.43

0.66

50

500000

3562

4493

3927.2

1.01

2.02

1.17

50

600000

3965

4953

4297.1

0.9

0.91

0.91

50

700000

4983

7320

5548.8

0.8

0.68

0.77

50

800000

5733

8707

6967.8

0.87

0.84

0.8

50

900000

7575

9002

8258.5

0.76

0.97

0.84

50

1000000

9320

26861

17746.6

0.81

0.34

0.47

Number of Fields 100

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 5656, 9109, 15154, 20537, 27343, 33815, 41986, 48619, 83967, 58621 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 11754, 23810, 20422, 29360, 42598, 52748, 78931, 59930, 98283, 84241 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 6821.9, 12577.8, 16509.2, 22571.5, 33434.5, 38520.4, 59694.6, 53338.8, 91999
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

5656

11754

6821.9

1

1

1

100

200000

9109

23810

12577.8

0.62

0.49

0.54

100

300000

15154

20422

16509.2

0.6

1.17

0.76

100

400000

20537

29360

22571.5

0.74

0.7

0.73

100

500000

27343

42598

33434.5

0.75

0.69

0.68

100

600000

33815

52748

38520.4

0.81

0.81

0.87

100

700000

41986

78931

59694.6

0.81

0.67

0.65

100

800000

48619

59930

53338.8

0.86

1.32

1.12

100

900000

83967

98283

91999.9

0.58

0.61

0.58

100

1000000

58621

84241

71139

1.43

1.17

1.29

Listing Records: Searching

The scenario benchmarks fetching the first page of records without any other sorting/filtering parameters. The page size is 20 records.

The scenario excludes both the total record count and the complete paging navigation.

Number of Fields 1

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 127, 141, 184, 190, 192, 204, 219, 275, 217, 312 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 184, 263, 357, 325, 451, 491, 740, 928, 584, 687 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 154.5, 174.6, 233.8, 230.2, 294.1, 288.2, 372.2, 359.6, 347.3, 395
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

127

184

154.5

1

1

1

1

200000

141

263

174.6

0.9

0.7

0.88

1

300000

184

357

233.8

0.77

0.74

0.75

1

400000

190

325

230.2

0.97

1.1

1.02

1

500000

192

451

294.1

0.99

0.72

0.78

1

600000

204

491

288.2

0.94

0.92

1.02

1

700000

219

740

372.2

0.93

0.66

0.77

1

800000

275

928

359.6

0.8

0.8

1.04

1

900000

217

584

347.3

1.27

1.59

1.04

1

1000000

312

687

395.6

0.7

0.85

0.88

Number of Fields 10

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 165, 166, 262, 272, 305, 340, 321, 466, 463, 428 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 497, 479, 641, 704, 869, 819, 1982, 1314, 2071, 2067 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 237.2, 295.6, 359.5, 386.1, 409.1, 507.4, 603.8, 637.4, 823.1, 813
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

165

497

237.2

1

1

1

10

200000

166

479

295.6

0.99

1.04

0.8

10

300000

262

641

359.5

0.63

0.75

0.82

10

400000

272

704

386.1

0.96

0.91

0.93

10

500000

305

869

409.1

0.89

0.81

0.94

10

600000

340

819

507.4

0.9

1.06

0.81

10

700000

321

1982

603.8

1.06

0.41

0.84

10

800000

466

1314

637.4

0.69

1.51

0.95

10

900000

463

2071

823.1

1.01

0.63

0.77

10

1000000

428

2067

813.8

1.08

1

1.01

Number of Fields 50

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 335, 395, 594, 720, 898, 993, 1028, 1228, 1278, 1362 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 1083, 1938, 1918, 2738, 3077, 2609, 2853, 3492, 3661, 5229 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 530.2, 676.6, 899.8, 1051.5, 1265.5, 1282.8, 1485.4, 1784.4, 1778.8, 2102
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

335

1083

530.2

1

1

1

50

200000

395

1938

676.6

0.85

0.56

0.78

50

300000

594

1918

899.8

0.66

1.01

0.75

50

400000

720

2738

1051.5

0.83

0.7

0.86

50

500000

898

3077

1265.5

0.8

0.89

0.83

50

600000

993

2609

1282.8

0.9

1.18

0.99

50

700000

1028

2853

1485.4

0.97

0.91

0.86

50

800000

1228

3492

1784.4

0.84

0.82

0.83

50

900000

1278

3661

1778.8

0.96

0.95

1

50

1000000

1362

5229

2102.7

0.94

0.7

0.85

Number of Fields 100

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 354, 346, 454, 414, 416, 480, 437, 465, 478, 407 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 441, 429, 584, 553, 572, 731, 644, 737, 1129, 1307 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 370.8, 399.7, 493.7, 468.7, 479, 555.7, 522.5, 556.3, 596, 770
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

354

441

370.8

1

1

1

100

200000

346

429

399.7

1.02

1.03

0.93

100

300000

454

584

493.7

0.76

0.73

0.81

100

400000

414

553

468.7

1.1

1.06

1.05

100

500000

416

572

479

1

0.97

0.98

100

600000

480

731

555.7

0.87

0.78

0.86

100

700000

437

644

522.5

1.1

1.14

1.06

100

800000

465

737

556.3

0.94

0.87

0.94

100

900000

478

1129

596

0.97

0.65

0.93

100

1000000

407

1307

770.5

1.17

0.86

0.77

Sorting Records: Searching

The scenario benchmarks fetching the first page of records when providing a sort. The page size is 20 records.

The scenario excludes both the total record count and the complete paging navigation.

Number of Fields 1

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 153, 176, 227, 283, 306, 289, 384, 373, 485, 554 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 185, 279, 479, 693, 388, 360, 856, 750, 1079, 1440 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 163, 209.6, 337.5, 422.9, 356.4, 319.2, 540.5, 472.3, 678.4, 771
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

153

185

163

1

1

1

1

200000

176

279

209.6

0.87

0.66

0.78

1

300000

227

479

337.5

0.78

0.58

0.62

1

400000

283

693

422.9

0.8

0.69

0.8

1

500000

306

388

356.4

0.92

1.79

1.19

1

600000

289

360

319.2

1.06

1.08

1.12

1

700000

384

856

540.5

0.75

0.42

0.59

1

800000

373

750

472.3

1.03

1.14

1.14

1

900000

485

1079

678.4

0.77

0.7

0.7

1

1000000

554

1440

771.4

0.88

0.75

0.88

Number of Fields 10

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 291, 669, 833, 1176, 843, 977, 1478, 1614, 2009, 2618 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 409, 2063, 2111, 2866, 1501, 1053, 2192, 2334, 3414, 6860 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 312.9, 1066.1, 1125.6, 1855.6, 980.9, 1010.5, 1728.8, 1867.9, 2467.8, 4126
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

291

409

312.9

1

1

1

10

200000

669

2063

1066.1

0.43

0.2

0.29

10

300000

833

2111

1125.6

0.8

0.98

0.95

10

400000

1176

2866

1855.6

0.71

0.74

0.61

10

500000

843

1501

980.9

1.4

1.91

1.89

10

600000

977

1053

1010.5

0.86

1.43

0.97

10

700000

1478

2192

1728.8

0.66

0.48

0.58

10

800000

1614

2334

1867.9

0.92

0.94

0.93

10

900000

2009

3414

2467.8

0.8

0.68

0.76

10

1000000

2618

6860

4126.4

0.77

0.5

0.6

Number of Fields 50

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 521, 1873, 2893, 3474, 3285, 2673, 4944, 6060, 8875, 8397 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 627, 4525, 8615, 9207, 4420, 5023, 7427, 8959, 23484, 28815 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 560.9, 2770.3, 4972.9, 5120.5, 3741, 3939.3, 5697.8, 6605.6, 12285.7, 13872
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

521

627

560.9

1

1

1

50

200000

1873

4525

2770.3

0.28

0.14

0.2

50

300000

2893

8615

4972.9

0.65

0.53

0.56

50

400000

3474

9207

5120.5

0.83

0.94

0.97

50

500000

3285

4420

3741

1.06

2.08

1.37

50

600000

2673

5023

3939.3

1.23

0.88

0.95

50

700000

4944

7427

5697.8

0.54

0.68

0.69

50

800000

6060

8959

6605.6

0.82

0.83

0.86

50

900000

8875

23484

12285.7

0.68

0.38

0.54

50

1000000

8397

28815

13872.1

1.06

0.81

0.89

Number of Fields 100

chart?bkg=white&c={ 'type': 'line', 'data': { 'labels': [ '100000', '200000', '300000', '400000', '500000', '600000', '700000', '800000', '900000', '1000000' ], 'datasets': [ { 'label': 'Min', 'data': [ 4269, 9678, 20708, 25743, 24804, 30332, 41961, 45881, 83982, 52443 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 5611, 26862, 37772, 65667, 36126, 35392, 78030, 59383, 145701, 69243 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 4583, 14043.2, 27065.8, 36611.5, 27865.9, 33364.3, 59373.5, 51142.4, 98477.4, 57934
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

4269

5611

4583

1

1

1

100

200000

9678

26862

14043.2

0.44

0.21

0.33

100

300000

20708

37772

27065.8

0.47

0.71

0.52

100

400000

25743

65667

36611.5

0.8

0.58

0.74

100

500000

24804

36126

27865.9

1.04

1.82

1.31

100

600000

30332

35392

33364.3

0.82

1.02

0.84

100

700000

41961

78030

59373.5

0.72

0.45

0.56

100

800000

45881

59383

51142.4

0.91

1.31

1.16

100

900000

83982

145701

98477.4

0.55

0.41

0.52

100

1000000

52443

69243

57934.5

1.6

2.1

1.7