You are reading the documentation for an outdated Corteza release. 2023.9 is the latest stable Corteza release.

Benchmark for Dedicated Tables

The dedicated table benchmarks the optimized setup where module fields get their own dedicated table columns. You can apply standard database optimizations (such as indexing) to better suit your needs. This setup is intended for high volume modules since it can better utilize indexing and reduce the JSON encoding overhead.

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:

  • A sub-select of columns specified indexes which affects both the CRUD and search operations.

  • 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 to define a dedicated column for each module field. The primary reason is consistent repeatability.

  • 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': [ 140, 134, 128, 142, 147, 140, 139, 128, 142, 116 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 208, 161, 180, 168, 158, 152, 2693, 156, 180, 162 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 157.3, 146.1, 147.4, 150.5, 150.1, 146.5, 403.4, 144.5, 153.6, 137
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

140

208

157.3

1

1

1

1

200000

134

161

146.1

1.04

1.29

1.08

1

300000

128

180

147.4

1.05

0.89

0.99

1

400000

142

168

150.5

0.9

1.07

0.98

1

500000

147

158

150.1

0.97

1.06

1

1

600000

140

152

146.5

1.05

1.04

1.02

1

700000

139

2693

403.4

1.01

0.06

0.36

1

800000

128

156

144.5

1.09

17.26

2.79

1

900000

142

180

153.6

0.9

0.87

0.94

1

1000000

116

162

137.3

1.22

1.11

1.12

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': [ 139, 123, 131, 132, 146, 146, 146, 144, 139, 138 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 166, 159, 177, 211, 164, 222, 188, 170, 208, 227 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 152.1, 137.7, 145.2, 158, 151.8, 160, 160.5, 151.8, 161.6, 159
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

139

166

152.1

1

1

1

10

200000

123

159

137.7

1.13

1.04

1.1

10

300000

131

177

145.2

0.94

0.9

0.95

10

400000

132

211

158

0.99

0.84

0.92

10

500000

146

164

151.8

0.9

1.29

1.04

10

600000

146

222

160

1

0.74

0.95

10

700000

146

188

160.5

1

1.18

1

10

800000

144

170

151.8

1.01

1.11

1.06

10

900000

139

208

161.6

1.04

0.82

0.94

10

1000000

138

227

159.5

1.01

0.92

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': [ 138, 134, 137, 132, 140, 135, 148, 144, 142, 144 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 204, 167, 181, 225, 214, 183, 174, 184, 166, 166 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 159.3, 145.8, 155.6, 154.2, 160.5, 155.3, 156.3, 157.6, 153.1, 154
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

138

204

159.3

1

1

1

50

200000

134

167

145.8

1.03

1.22

1.09

50

300000

137

181

155.6

0.98

0.92

0.94

50

400000

132

225

154.2

1.04

0.8

1.01

50

500000

140

214

160.5

0.94

1.05

0.96

50

600000

135

183

155.3

1.04

1.17

1.03

50

700000

148

174

156.3

0.91

1.05

0.99

50

800000

144

184

157.6

1.03

0.95

0.99

50

900000

142

166

153.1

1.01

1.11

1.03

50

1000000

144

166

154.2

0.99

1

0.99

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': [ 164, 154, 150, 149, 153, 161, 142, 145, 152, 150 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 607, 194, 192, 195, 229, 262, 190, 276, 196, 178 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 215.7, 168, 170, 168.9, 174.5, 181.4, 163.2, 179.3, 170.9, 164
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

164

607

215.7

1

1

1

100

200000

154

194

168

1.06

3.13

1.28

100

300000

150

192

170

1.03

1.01

0.99

100

400000

149

195

168.9

1.01

0.98

1.01

100

500000

153

229

174.5

0.97

0.85

0.97

100

600000

161

262

181.4

0.95

0.87

0.96

100

700000

142

190

163.2

1.13

1.38

1.11

100

800000

145

276

179.3

0.98

0.69

0.91

100

900000

152

196

170.9

0.95

1.41

1.05

100

1000000

150

178

164.4

1.01

1.1

1.04

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': [ 138, 118, 118, 133, 141, 133, 125, 129, 144, 119 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 157, 164, 147, 159, 176, 157, 157, 166, 155, 153 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 145.4, 136.8, 133.9, 145.7, 150.9, 146.6, 145.4, 145.1, 148
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

138

157

145.4

1

1

1

1

200000

118

164

136.8

1.17

0.96

1.06

1

300000

118

147

133.9

1

1.12

1.02

1

400000

133

159

145.7

0.89

0.92

0.92

1

500000

141

176

150.9

0.94

0.9

0.97

1

600000

133

157

146.6

1.06

1.12

1.03

1

700000

125

157

145.4

1.06

1

1.01

1

800000

129

166

145.1

0.97

0.95

1

1

900000

144

155

148.9

0.9

1.07

0.97

1

1000000

119

153

139

1.21

1.01

1.07

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': [ 142, 116, 114, 114, 146, 146, 141, 137, 128, 112 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 173, 150, 181, 203, 214, 155, 192, 169, 174, 172 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 150.7, 138.4, 146.4, 147.3, 161.1, 148.9, 156.1, 151.1, 153.7, 141
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

142

173

150.7

1

1

1

10

200000

116

150

138.4

1.22

1.15

1.09

10

300000

114

181

146.4

1.02

0.83

0.95

10

400000

114

203

147.3

1

0.89

0.99

10

500000

146

214

161.1

0.78

0.95

0.91

10

600000

146

155

148.9

1

1.38

1.08

10

700000

141

192

156.1

1.04

0.81

0.95

10

800000

137

169

151.1

1.03

1.14

1.03

10

900000

128

174

153.7

1.07

0.97

0.98

10

1000000

112

172

141.7

1.14

1.01

1.08

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': [ 146, 129, 134, 128, 143, 132, 140, 146, 123, 128 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 198, 155, 216, 154, 197, 157, 157, 206, 183, 162 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 154.2, 141.1, 159.1, 140.5, 158.4, 146.8, 148, 157.4, 151.5, 143
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

146

198

154.2

1

1

1

50

200000

129

155

141.1

1.13

1.28

1.09

50

300000

134

216

159.1

0.96

0.72

0.89

50

400000

128

154

140.5

1.05

1.4

1.13

50

500000

143

197

158.4

0.9

0.78

0.89

50

600000

132

157

146.8

1.08

1.25

1.08

50

700000

140

157

148

0.94

1

0.99

50

800000

146

206

157.4

0.96

0.76

0.94

50

900000

123

183

151.5

1.19

1.13

1.04

50

1000000

128

162

143.7

0.96

1.13

1.05

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': [ 156, 126, 134, 140, 124, 142, 132, 132, 135, 132 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 403, 162, 159, 184, 167, 174, 203, 215, 204, 166 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 194, 148.8, 149.2, 155.8, 151.6, 160, 151.6, 164.3, 159.2, 149
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

156

403

194

1

1

1

100

200000

126

162

148.8

1.24

2.49

1.3

100

300000

134

159

149.2

0.94

1.02

1

100

400000

140

184

155.8

0.96

0.86

0.96

100

500000

124

167

151.6

1.13

1.1

1.03

100

600000

142

174

160

0.87

0.96

0.95

100

700000

132

203

151.6

1.08

0.86

1.06

100

800000

132

215

164.3

1

0.94

0.92

100

900000

135

204

159.2

0.98

1.05

1.03

100

1000000

132

166

149.5

1.02

1.23

1.06

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': [ 139, 123, 129, 138, 142, 139, 139, 131, 143, 128 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 164, 163, 201, 166, 158, 183, 191, 212, 172, 157 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 152.3, 142.7, 147.4, 154.1, 151.2, 149.5, 153.4, 157.7, 154
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

139

164

152.3

1

1

1

1

200000

123

163

142.7

1.13

1.01

1.07

1

300000

129

201

147.4

0.95

0.81

0.97

1

400000

138

166

154.1

0.93

1.21

0.96

1

500000

142

158

151.2

0.97

1.05

1.02

1

600000

139

183

149.5

1.02

0.86

1.01

1

700000

139

191

153.4

1

0.96

0.97

1

800000

131

212

157.7

1.06

0.9

0.97

1

900000

143

172

154.4

0.92

1.23

1.02

1

1000000

128

157

142

1.12

1.1

1.09

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': [ 145, 132, 142, 137, 141, 148, 134, 147, 148, 131 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 168, 152, 184, 202, 208, 164, 349, 174, 174, 184 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 154.4, 141.8, 153.9, 154.1, 161.3, 155.8, 180.1, 157.2, 156.6, 148
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

145

168

154.4

1

1

1

10

200000

132

152

141.8

1.1

1.11

1.09

10

300000

142

184

153.9

0.93

0.83

0.92

10

400000

137

202

154.1

1.04

0.91

1

10

500000

141

208

161.3

0.97

0.97

0.96

10

600000

148

164

155.8

0.95

1.27

1.04

10

700000

134

349

180.1

1.1

0.47

0.87

10

800000

147

174

157.2

0.91

2.01

1.15

10

900000

148

174

156.6

0.99

1

1

10

1000000

131

184

148.5

1.13

0.95

1.05

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': [ 141, 129, 141, 139, 146, 144, 150, 138, 141, 127 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 166, 195, 207, 197, 167, 163, 170, 198, 213, 196 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 151.5, 147, 162.3, 163.2, 154, 152.6, 157.6, 157.3, 161.5, 158
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

141

166

151.5

1

1

1

50

200000

129

195

147

1.09

0.85

1.03

50

300000

141

207

162.3

0.91

0.94

0.91

50

400000

139

197

163.2

1.01

1.05

0.99

50

500000

146

167

154

0.95

1.18

1.06

50

600000

144

163

152.6

1.01

1.02

1.01

50

700000

150

170

157.6

0.96

0.96

0.97

50

800000

138

198

157.3

1.09

0.86

1

50

900000

141

213

161.5

0.98

0.93

0.97

50

1000000

127

196

158.6

1.11

1.09

1.02

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': [ 165, 147, 161, 162, 153, 161, 161, 152, 145, 152 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 214, 190, 186, 205, 174, 1726, 186, 194, 181, 234 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 178.3, 162.9, 171.5, 180.2, 165.6, 333.7, 173.4, 169.2, 166.1, 169
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

165

214

178.3

1

1

1

100

200000

147

190

162.9

1.12

1.13

1.09

100

300000

161

186

171.5

0.91

1.02

0.95

100

400000

162

205

180.2

0.99

0.91

0.95

100

500000

153

174

165.6

1.06

1.18

1.09

100

600000

161

1726

333.7

0.95

0.1

0.5

100

700000

161

186

173.4

1

9.28

1.92

100

800000

152

194

169.2

1.06

0.96

1.02

100

900000

145

181

166.1

1.05

1.07

1.02

100

1000000

152

234

169.5

0.95

0.77

0.98

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': [ 139, 123, 122, 140, 146, 140, 140, 137, 139, 124 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 164, 160, 204, 165, 163, 157, 185, 165, 169, 157 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 149.7, 142.5, 143.4, 152.1, 152.2, 147.5, 151.9, 151.1, 151.4, 135
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

139

164

149.7

1

1

1

1

200000

123

160

142.5

1.13

1.02

1.05

1

300000

122

204

143.4

1.01

0.78

0.99

1

400000

140

165

152.1

0.87

1.24

0.94

1

500000

146

163

152.2

0.96

1.01

1

1

600000

140

157

147.5

1.04

1.04

1.03

1

700000

140

185

151.9

1

0.85

0.97

1

800000

137

165

151.1

1.02

1.12

1.01

1

900000

139

169

151.4

0.99

0.98

1

1

1000000

124

157

135.5

1.12

1.08

1.12

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': [ 134, 116, 129, 128, 140, 144, 146, 140, 140, 118 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 173, 163, 157, 165, 173, 195, 172, 183, 174, 173 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 149.7, 140.5, 140.9, 142.5, 154.5, 154.3, 154.2, 155.9, 152.1, 148
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

134

173

149.7

1

1

1

10

200000

116

163

140.5

1.16

1.06

1.07

10

300000

129

157

140.9

0.9

1.04

1

10

400000

128

165

142.5

1.01

0.95

0.99

10

500000

140

173

154.5

0.91

0.95

0.92

10

600000

144

195

154.3

0.97

0.89

1

10

700000

146

172

154.2

0.99

1.13

1

10

800000

140

183

155.9

1.04

0.94

0.99

10

900000

140

174

152.1

1

1.05

1.02

10

1000000

118

173

148.9

1.19

1.01

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': [ 144, 136, 124, 130, 140, 145, 137, 141, 126, 129 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 224, 192, 166, 153, 166, 154, 166, 164, 162, 195 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 156, 156.4, 146.6, 144.2, 150.4, 148.3, 148.3, 149, 147.1, 151
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

144

224

156

1

1

1

50

200000

136

192

156.4

1.06

1.17

1

50

300000

124

166

146.6

1.1

1.16

1.07

50

400000

130

153

144.2

0.95

1.08

1.02

50

500000

140

166

150.4

0.93

0.92

0.96

50

600000

145

154

148.3

0.97

1.08

1.01

50

700000

137

166

148.3

1.06

0.93

1

50

800000

141

164

149

0.97

1.01

1

50

900000

126

162

147.1

1.12

1.01

1.01

50

1000000

129

195

151.9

0.98

0.83

0.97

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': [ 148, 137, 135, 137, 136, 142, 146, 132, 129, 127 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 200, 168, 183, 162, 168, 253, 222, 170, 184, 203 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 168.3, 152.5, 154, 152.3, 154.8, 166.8, 168.6, 153.4, 151.3, 155
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

148

200

168.3

1

1

1

100

200000

137

168

152.5

1.08

1.19

1.1

100

300000

135

183

154

1.01

0.92

0.99

100

400000

137

162

152.3

0.99

1.13

1.01

100

500000

136

168

154.8

1.01

0.96

0.98

100

600000

142

253

166.8

0.96

0.66

0.93

100

700000

146

222

168.6

0.97

1.14

0.99

100

800000

132

170

153.4

1.11

1.31

1.1

100

900000

129

184

151.3

1.02

0.92

1.01

100

1000000

127

203

155.4

1.02

0.91

0.97

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': [ 132, 136, 125, 121, 126, 115, 129, 131, 124, 135 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 160, 188, 164, 208, 179, 168, 154, 190, 165, 160 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 146.4, 153.1, 143.6, 150.1, 141.6, 149.3, 142.3, 146.7, 143.9, 146
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

132

160

146.4

1

1

1

1

200000

136

188

153.1

0.97

0.85

0.96

1

300000

125

164

143.6

1.09

1.15

1.07

1

400000

121

208

150.1

1.03

0.79

0.96

1

500000

126

179

141.6

0.96

1.16

1.06

1

600000

115

168

149.3

1.1

1.07

0.95

1

700000

129

154

142.3

0.89

1.09

1.05

1

800000

131

190

146.7

0.98

0.81

0.97

1

900000

124

165

143.9

1.06

1.15

1.02

1

1000000

135

160

146.8

0.92

1.03

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': [ 157, 163, 167, 168, 171, 169, 168, 175, 172, 175 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 239, 208, 195, 223, 204, 214, 205, 223, 207, 243 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 188.8, 183.2, 184.4, 198.5, 186.5, 187.3, 184.9, 192.1, 189.7, 192
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

157

239

188.8

1

1

1

10

200000

163

208

183.2

0.96

1.15

1.03

10

300000

167

195

184.4

0.98

1.07

0.99

10

400000

168

223

198.5

0.99

0.87

0.93

10

500000

171

204

186.5

0.98

1.09

1.06

10

600000

169

214

187.3

1.01

0.95

1

10

700000

168

205

184.9

1.01

1.04

1.01

10

800000

175

223

192.1

0.96

0.92

0.96

10

900000

172

207

189.7

1.02

1.08

1.01

10

1000000

175

243

192.9

0.98

0.85

0.98

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': [ 224, 208, 220, 225, 216, 222, 207, 211, 217, 217 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 269, 259, 268, 253, 259, 260, 303, 282, 295, 265 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 244.4, 237.4, 246.3, 237.6, 238, 239, 240.7, 240.7, 247.4, 236
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

224

269

244.4

1

1

1

50

200000

208

259

237.4

1.08

1.04

1.03

50

300000

220

268

246.3

0.95

0.97

0.96

50

400000

225

253

237.6

0.98

1.06

1.04

50

500000

216

259

238

1.04

0.98

1

50

600000

222

260

239

0.97

1

1

50

700000

207

303

240.7

1.07

0.86

0.99

50

800000

211

282

240.7

0.98

1.07

1

50

900000

217

295

247.4

0.97

0.96

0.97

50

1000000

217

265

236.5

1

1.11

1.05

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': [ 344, 347, 326, 329, 334, 353, 363, 353, 362, 333 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 490, 381, 399, 392, 430, 430, 439, 399, 479, 381 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 393.6, 359.8, 363.7, 365.6, 384.2, 394.8, 393.5, 373.1, 392, 355
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

344

490

393.6

1

1

1

100

200000

347

381

359.8

0.99

1.29

1.09

100

300000

326

399

363.7

1.06

0.95

0.99

100

400000

329

392

365.6

0.99

1.02

0.99

100

500000

334

430

384.2

0.99

0.91

0.95

100

600000

353

430

394.8

0.95

1

0.97

100

700000

363

439

393.5

0.97

0.98

1

100

800000

353

399

373.1

1.03

1.1

1.05

100

900000

362

479

392

0.98

0.83

0.95

100

1000000

333

381

355.6

1.09

1.26

1.1

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': [ 169, 180, 211, 233, 301, 332, 373, 365, 455, 478 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 363, 264, 562, 1027, 1229, 1209, 1719, 1645, 754, 2027 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 201.4, 208.1, 273.3, 341.6, 426, 448, 536.2, 544.9, 544.2, 671
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

169

363

201.4

1

1

1

1

200000

180

264

208.1

0.94

1.38

0.97

1

300000

211

562

273.3

0.85

0.47

0.76

1

400000

233

1027

341.6

0.91

0.55

0.8

1

500000

301

1229

426

0.77

0.84

0.8

1

600000

332

1209

448

0.91

1.02

0.95

1

700000

373

1719

536.2

0.89

0.7

0.84

1

800000

365

1645

544.9

1.02

1.04

0.98

1

900000

455

754

544.2

0.8

2.18

1

1

1000000

478

2027

671.1

0.95

0.37

0.81

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': [ 182, 157, 186, 160, 155, 168, 180, 172, 178, 163 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 636, 203, 341, 420, 452, 576, 648, 657, 364, 1460 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 237.3, 180.7, 218.1, 212.5, 222.6, 240.7, 238.1, 235.7, 216.8, 319
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

182

636

237.3

1

1

1

10

200000

157

203

180.7

1.16

3.13

1.31

10

300000

186

341

218.1

0.84

0.6

0.83

10

400000

160

420

212.5

1.16

0.81

1.03

10

500000

155

452

222.6

1.03

0.93

0.95

10

600000

168

576

240.7

0.92

0.78

0.92

10

700000

180

648

238.1

0.93

0.89

1.01

10

800000

172

657

235.7

1.05

0.99

1.01

10

900000

178

364

216.8

0.97

1.8

1.09

10

1000000

163

1460

319.3

1.09

0.25

0.68

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': [ 233, 217, 231, 228, 221, 248, 229, 224, 212, 234 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 296, 384, 439, 436, 495, 556, 697, 265, 457, 1295 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 255.7, 248.3, 271.1, 268.6, 270.4, 289.6, 297.5, 247.2, 282.8, 360
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

233

296

255.7

1

1

1

50

200000

217

384

248.3

1.07

0.77

1.03

50

300000

231

439

271.1

0.94

0.87

0.92

50

400000

228

436

268.6

1.01

1.01

1.01

50

500000

221

495

270.4

1.03

0.88

0.99

50

600000

248

556

289.6

0.89

0.89

0.93

50

700000

229

697

297.5

1.08

0.8

0.97

50

800000

224

265

247.2

1.02

2.63

1.2

50

900000

212

457

282.8

1.06

0.58

0.87

50

1000000

234

1295

360.1

0.91

0.35

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': [ 345, 351, 358, 371, 359, 385, 364, 357, 359, 368 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 473, 414, 799, 741, 824, 1308, 869, 1090, 832, 1460 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 406.7, 372.6, 420.5, 431, 459.7, 495.5, 446.1, 475.1, 451.3, 493
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

345

473

406.7

1

1

1

100

200000

351

414

372.6

0.98

1.14

1.09

100

300000

358

799

420.5

0.98

0.52

0.89

100

400000

371

741

431

0.96

1.08

0.98

100

500000

359

824

459.7

1.03

0.9

0.94

100

600000

385

1308

495.5

0.93

0.63

0.93

100

700000

364

869

446.1

1.06

1.51

1.11

100

800000

357

1090

475.1

1.02

0.8

0.94

100

900000

359

832

451.3

0.99

1.31

1.05

100

1000000

368

1460

493.8

0.98

0.57

0.91

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': [ 130, 137, 126, 121, 134, 130, 119, 132, 129, 124 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 167, 162, 157, 164, 178, 192, 164, 162, 180, 165 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 146.1, 149.1, 142.8, 141.7, 141.6, 150.5, 137.4, 145.1, 144.3, 139
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

130

167

146.1

1

1

1

1

200000

137

162

149.1

0.95

1.03

0.98

1

300000

126

157

142.8

1.09

1.03

1.04

1

400000

121

164

141.7

1.04

0.96

1.01

1

500000

134

178

141.6

0.9

0.92

1

1

600000

130

192

150.5

1.03

0.93

0.94

1

700000

119

164

137.4

1.09

1.17

1.1

1

800000

132

162

145.1

0.9

1.01

0.95

1

900000

129

180

144.3

1.02

0.9

1.01

1

1000000

124

165

139.7

1.04

1.09

1.03

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': [ 157, 159, 165, 176, 179, 147, 149, 163, 165, 173 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 262, 197, 205, 222, 197, 215, 216, 214, 212, 233 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 192.9, 178.4, 186.3, 193, 187.7, 188, 187.2, 184.4, 183, 197
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

157

262

192.9

1

1

1

10

200000

159

197

178.4

0.99

1.33

1.08

10

300000

165

205

186.3

0.96

0.96

0.96

10

400000

176

222

193

0.94

0.92

0.97

10

500000

179

197

187.7

0.98

1.13

1.03

10

600000

147

215

188

1.22

0.92

1

10

700000

149

216

187.2

0.99

1

1

10

800000

163

214

184.4

0.91

1.01

1.02

10

900000

165

212

183

0.99

1.01

1.01

10

1000000

173

233

197.2

0.95

0.91

0.93

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': [ 221, 210, 205, 217, 216, 220, 207, 208, 198, 211 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 262, 258, 273, 260, 245, 285, 303, 263, 274, 260 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 236.5, 233.9, 242.9, 235.8, 231.7, 241.9, 250.7, 238.8, 236
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

221

262

236.5

1

1

1

50

200000

210

258

233.9

1.05

1.02

1.01

50

300000

205

273

242.9

1.02

0.95

0.96

50

400000

217

260

235.8

0.94

1.05

1.03

50

500000

216

245

231.7

1

1.06

1.02

50

600000

220

285

241.9

0.98

0.86

0.96

50

700000

207

303

250.7

1.06

0.94

0.96

50

800000

208

263

238.8

1

1.15

1.05

50

900000

198

274

236.9

1.05

0.96

1.01

50

1000000

211

260

232

0.94

1.05

1.02

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': [ 351, 334, 340, 349, 343, 354, 340, 347, 324, 327 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 450, 392, 396, 427, 416, 415, 415, 424, 424, 395 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 391.3, 359.8, 370.1, 386.4, 376.5, 386.8, 391.7, 379.3, 380.5, 363
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

351

450

391.3

1

1

1

100

200000

334

392

359.8

1.05

1.15

1.09

100

300000

340

396

370.1

0.98

0.99

0.97

100

400000

349

427

386.4

0.97

0.93

0.96

100

500000

343

416

376.5

1.02

1.03

1.03

100

600000

354

415

386.8

0.97

1

0.97

100

700000

340

415

391.7

1.04

1

0.99

100

800000

347

424

379.3

0.98

0.98

1.03

100

900000

324

424

380.5

1.07

1

1

100

1000000

327

395

363.1

0.99

1.07

1.05

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': [ 136, 135, 136, 132, 131, 134, 134, 135, 126, 138 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 213, 171, 286, 834, 416, 481, 638, 591, 184, 670 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 155.6, 146.7, 164.5, 214.8, 171.8, 195.8, 198.6, 193.1, 150.7, 198
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

1

100000

136

213

155.6

1

1

1

1

200000

135

171

146.7

1.01

1.25

1.06

1

300000

136

286

164.5

0.99

0.6

0.89

1

400000

132

834

214.8

1.03

0.34

0.77

1

500000

131

416

171.8

1.01

2

1.25

1

600000

134

481

195.8

0.98

0.86

0.88

1

700000

134

638

198.6

1

0.75

0.99

1

800000

135

591

193.1

0.99

1.08

1.03

1

900000

126

184

150.7

1.07

3.21

1.28

1

1000000

138

670

198.7

0.91

0.27

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': [ 175, 157, 191, 159, 172, 181, 182, 170, 182, 144 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 296, 205, 340, 485, 410, 441, 575, 629, 403, 732 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 205.2, 180.9, 217, 220.4, 224.4, 230.2, 227.4, 232.2, 220
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

10

100000

175

296

205.2

1

1

1

10

200000

157

205

180.9

1.11

1.44

1.13

10

300000

191

340

217

0.82

0.6

0.83

10

400000

159

485

220.4

1.2

0.7

0.98

10

500000

172

410

224.4

0.92

1.18

0.98

10

600000

181

441

230.2

0.95

0.93

0.97

10

700000

182

575

227.4

0.99

0.77

1.01

10

800000

170

629

232.2

1.07

0.91

0.98

10

900000

182

403

220.4

0.93

1.56

1.05

10

1000000

144

732

246

1.26

0.55

0.9

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': [ 225, 203, 217, 220, 209, 220, 230, 205, 230, 217 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 289, 284, 409, 524, 532, 539, 703, 248, 492, 879 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 245.6, 238.3, 266.6, 265.1, 272.3, 271.4, 286.3, 234, 268.9, 308
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

50

100000

225

289

245.6

1

1

1

50

200000

203

284

238.3

1.11

1.02

1.03

50

300000

217

409

266.6

0.94

0.69

0.89

50

400000

220

524

265.1

0.99

0.78

1.01

50

500000

209

532

272.3

1.05

0.98

0.97

50

600000

220

539

271.4

0.95

0.99

1

50

700000

230

703

286.3

0.96

0.77

0.95

50

800000

205

248

234

1.12

2.83

1.22

50

900000

230

492

268.9

0.89

0.5

0.87

50

1000000

217

879

308.8

1.06

0.56

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': [ 363, 352, 347, 385, 396, 377, 377, 407, 406, 380 ], 'fill': false, 'borderColor': 'rgb(67, 170, 139)' }, { 'label': 'Max', 'data': [ 546, 422, 820, 810, 809, 1050, 881, 1378, 669, 1578 ], 'fill': false, 'borderColor': 'rgb(226, 70, 70)' }, { 'label': 'Avg', 'data': [ 416.5, 384.5, 446.6, 458.8, 487.4, 492.9, 458.9, 527.5, 460.7, 522
Field Count Pre-Created Record Count Min Max Avg Min Delta Max Delta Avg Delta

100

100000

363

546

416.5

1

1

1

100

200000

352

422

384.5

1.03

1.29

1.08

100

300000

347

820

446.6

1.01

0.51

0.86

100

400000

385

810

458.8

0.9

1.01

0.97

100

500000

396

809

487.4

0.97

1

0.94

100

600000

377

1050

492.9

1.05

0.77

0.99

100

700000

377

881

458.9

1

1.19

1.07

100

800000

407

1378

527.5

0.93

0.64

0.87

100

900000

406

669

460.7

1

2.06

1.14

100

1000000

380

1578

522.4

1.07

0.42

0.88