Untitled

EvEnSGRIANch

Feb 1st, 2022 (edited)

5,172

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

JSON 62.93 KB | None | 0 0

raw download clone embed print report

[
{
"Context": "Control: Using no encryption",
"TestSize": 10,
"SeedCount": 1000,
"AddUserTests": [
125915,
109700,
87624,
96303,
110093,
97157,
102967,
105412,
139721,
89647
],
"FindAndUpdateUserTests": [
192229,
121345,
104096,
88876,
98232,
100892,
120133,
90541,
100625,
86574
],
"UpdateUserTests": [
115270,
87651,
97321,
98133,
97710,
91371,
108267,
87039,
108001,
111011
]
},
{
"Context": "Control: using a fixed number of buckets",
"TestSize": 10,
"SeedCount": 1000,
"AddUserTests": [
387184,
123588,
145833,
125489,
107759,
97789,
116862,
111355,
155429,
106439
],
"FindAndUpdateUserTests": [
140736,
146311,
141659,
174228,
139698,
112702,
128414,
107844,
106583,
106817
],
"UpdateUserTests": [
100089,
97202,
96354,
102101,
110859,
121846,
124438,
108929,
105626,
94361
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 10,
"SeedCount": 1000,
"AddUserTests": [
400691,
181629,
178578,
325571,
277091,
213632,
219604,
230411,
232851,
249286
],
"FindAndUpdateUserTests": [
270336,
249826,
277684,
258408,
260940,
270210,
260713,
262322,
263575,
281274
],
"UpdateUserTests": [
269038,
265077,
270030,
247109,
242536,
252842,
249719,
276344,
273388,
269117
]
},
{
"Context": "Using a summary table for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 10,
"SeedCount": 1000,
"AddUserTests": [
266057,
208420,
178676,
193731,
208675,
213283,
258683,
259354,
244300,
238287
],
"FindAndUpdateUserTests": [
267937,
277018,
292599,
279157,
251162,
250267,
247666,
253423,
253339,
269060
],
"UpdateUserTests": [
266536,
294245,
258685,
258493,
251259,
248941,
246978,
249891,
272175,
255044
]
},
{
"Context": "Using autoincremented row numbers",
"TestSize": 10,
"SeedCount": 1000,
"AddUserTests": [
223925,
170681,
170198,
203296,
220807,
216432,
241818,
232538,
224783,
246420
],
"FindAndUpdateUserTests": [
252342,
261797,
289953,
270112,
268567,
273613,
264937,
261278,
246931,
230709
],
"UpdateUserTests": [
238089,
252896,
259011,
270015,
267015,
263204,
271006,
252629,
252524,
259072
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, updating all bucket numbers after threshold is passed",
"TestSize": 10,
"SeedCount": 1000,
"AddUserTests": [
67273,
34529,
45961,
38198,
34042,
32439,
31803,
39787,
35189,
33348
],
"FindAndUpdateUserTests": [
134930,
134884,
137315,
127422,
123143,
138347,
146856,
113937,
160258,
141649
],
"UpdateUserTests": [
140440,
129264,
144075,
132971,
121115,
112827,
109957,
115862,
123194,
124116
]
},
{
"Context": "Control: Using no encryption",
"TestSize": 20,
"SeedCount": 1000,
"AddUserTests": [
102048,
79765,
90511,
96056,
92279,
84078,
134905,
142946,
87196,
86810,
77642,
81453,
68965,
77494,
78211,
90474,
96168,
69546,
77884,
66429
],
"FindAndUpdateUserTests": [
81919,
59407,
64863,
67176,
64392,
69668,
62392,
58927,
81152,
73265,
85632,
109036,
98112,
85337,
77434,
84450,
85414,
77449,
96957,
90788
],
"UpdateUserTests": [
93046,
82428,
74593,
86866,
66720,
74017,
90969,
83512,
74535,
88217,
94600,
92074,
102055,
94006,
102528,
98799,
98918,
92451,
81218,
63826
]
},
{
"Context": "Control: using a fixed number of buckets",
"TestSize": 20,
"SeedCount": 1000,
"AddUserTests": [
98299,
85442,
88366,
94688,
97916,
94108,
102121,
120411,
87906,
84495,
97974,
91976,
100875,
109937,
107985,
107730,
105837,
89417,
83785,
110233
],
"FindAndUpdateUserTests": [
110263,
100791,
95227,
91681,
101439,
97214,
222532,
110712,
112253,
94362,
95015,
85965,
99243,
84526,
110316,
93306,
87633,
99122,
98055,
93200
],
"UpdateUserTests": [
91376,
130653,
105125,
122158,
130953,
107435,
110699,
114817,
110464,
121475,
91102,
110287,
99555,
111306,
111283,
102663,
95852,
103838,
130393,
123397
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 20,
"SeedCount": 1000,
"AddUserTests": [
231521,
216606,
215943,
185591,
191287,
197354,
207217,
215933,
217363,
236370,
246014,
253276,
267834,
279297,
291885,
286623,
323141,
309019,
310627,
308702
],
"FindAndUpdateUserTests": [
328794,
378254,
381903,
374731,
343219,
370549,
338194,
327484,
343987,
367552,
350309,
372116,
349846,
355176,
360848,
320541,
327422,
349412,
363672,
381508
],
"UpdateUserTests": [
396138,
347374,
357834,
325260,
391736,
373131,
366369,
344527,
358639,
356688,
341857,
345675,
337638,
315677,
343424,
360157,
360297,
344439,
364705,
366212
]
},
{
"Context": "Using a summary table for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 20,
"SeedCount": 1000,
"AddUserTests": [
197575,
219961,
207896,
213221,
231721,
223388,
238625,
246049,
252885,
265719,
257550,
252336,
269592,
284268,
303186,
320063,
327020,
330970,
352937,
337840
],
"FindAndUpdateUserTests": [
313005,
351944,
338690,
342038,
354094,
361101,
352632,
345737,
347548,
319723,
329992,
336822,
343282,
347227,
350066,
372130,
357067,
321230,
319006,
338406
],
"UpdateUserTests": [
339486,
344906,
337174,
337069,
349268,
323144,
325960,
327756,
332195,
339165,
436477,
352482,
353570,
332876,
314325,
349220,
345906,
348043,
348904,
331638
]
},
{
"Context": "Using autoincremented row numbers",
"TestSize": 20,
"SeedCount": 1000,
"AddUserTests": [
165229,
154126,
167335,
195688,
212095,
211416,
218852,
220734,
229382,
243858,
254888,
274532,
278978,
276047,
272249,
289927,
312141,
298676,
303853,
317614
],
"FindAndUpdateUserTests": [
333143,
375286,
344971,
330827,
332933,
347115,
354462,
353142,
360634,
352254,
342486,
325645,
334837,
372966,
375800,
370132,
354513,
331766,
377899,
346608
],
"UpdateUserTests": [
324214,
334095,
366119,
357072,
368873,
465252,
364157,
352727,
327712,
316888,
330295,
353040,
333435,
378317,
365022,
369566,
346503,
320028,
326708,
322994
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, updating all bucket numbers after threshold is passed",
"TestSize": 20,
"SeedCount": 1000,
"AddUserTests": [
41042,
43823,
61234,
37340,
36427,
33058,
63264,
43109,
40487,
57112,
40283,
54857,
36397,
50099,
34550,
34053,
38604,
52671,
41540,
35862
],
"FindAndUpdateUserTests": [
119011,
149837,
118310,
134781,
136532,
129900,
133216,
149717,
151614,
137248,
118428,
143567,
122045,
101092,
104882,
103384,
105522,
100325,
102258,
105211
],
"UpdateUserTests": [
102869,
106381,
94411,
96952,
145092,
204043,
134266,
126916,
135773,
139431,
126315,
164945,
133351,
141000,
135688,
119556,
128672,
149521,
126161,
126590
]
},
{
"Context": "Control: Using no encryption",
"TestSize": 30,
"SeedCount": 1000,
"AddUserTests": [
78259,
79127,
70860,
78099,
71211,
77751,
82066,
66822,
104424,
97442,
104700,
91511,
88133,
80899,
77904,
73126,
83651,
78278,
69023,
76146,
89265,
95590,
96352,
89319,
87433,
87794,
70903,
79293,
90571,
80814
],
"FindAndUpdateUserTests": [
95246,
99786,
69172,
70004,
68036,
66335,
68857,
63716,
58453,
59593,
72820,
59472,
73930,
78254,
82674,
65929,
60931,
81875,
68828,
68618,
76766,
91133,
88368,
103410,
68646,
81036,
63766,
76100,
86116,
71180
],
"UpdateUserTests": [
69559,
89874,
94716,
83702,
79320,
67768,
77542,
74097,
67042,
99365,
76782,
94490,
88649,
105359,
98151,
100761,
101475,
103651,
81661,
71066,
77389,
76554,
89098,
87852,
95662,
72279,
82398,
83349,
78744,
91827
]
},
{
"Context": "Control: using a fixed number of buckets",
"TestSize": 30,
"SeedCount": 1000,
"AddUserTests": [
143568,
115438,
126894,
85813,
93387,
85128,
102187,
103198,
151743,
89008,
93293,
91899,
88943,
85849,
89991,
97049,
103007,
114622,
94736,
106159,
97498,
112095,
87211,
79493,
96239,
99243,
92516,
110818,
80981,
79616
],
"FindAndUpdateUserTests": [
93874,
88890,
82586,
86321,
98553,
104282,
101162,
100766,
107648,
126410,
99040,
90167,
101245,
88123,
102940,
111412,
102166,
107210,
114814,
99656,
108881,
120324,
110074,
103493,
147124,
114095,
122008,
116967,
94728,
93988
],
"UpdateUserTests": [
107260,
115093,
106019,
99001,
107461,
114260,
105380,
107340,
127429,
117159,
112135,
95151,
100139,
102777,
104729,
110059,
106514,
106371,
99968,
91756,
152230,
123801,
120114,
102089,
105343,
105955,
98128,
96454,
100330,
135328
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 30,
"SeedCount": 1000,
"AddUserTests": [
186664,
183612,
173935,
186729,
195353,
199596,
207363,
220455,
224294,
236374,
238975,
263691,
253124,
246123,
261771,
278987,
299355,
311666,
313343,
309410,
332918,
340997,
441698,
355895,
366713,
385144,
379414,
392746,
432807,
406623
],
"FindAndUpdateUserTests": [
401932,
442367,
442020,
422227,
429425,
427482,
421885,
421977,
465670,
446581,
425814,
430246,
440289,
413156,
421418,
424993,
431172,
437791,
430546,
406979,
418955,
461111,
434035,
418714,
443424,
419051,
408992,
417197,
414389,
423906
],
"UpdateUserTests": [
422652,
421046,
409871,
421906,
441410,
435933,
435410,
427016,
428091,
421156,
400914,
420785,
431259,
416598,
421315,
431253,
412191,
492582,
540019,
526973,
416374,
407955,
419032,
388512,
419927,
461032,
430591,
432283,
429345,
432161
]
},
{
"Context": "Using a summary table for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 30,
"SeedCount": 1000,
"AddUserTests": [
208731,
278937,
213173,
215883,
223765,
209869,
231237,
245687,
255155,
278936,
266315,
253414,
268338,
300411,
290266,
299737,
330462,
314441,
330258,
344817,
311784,
345324,
420405,
406446,
384234,
409437,
398746,
387730,
404422,
432046
],
"FindAndUpdateUserTests": [
412496,
451851,
429601,
483354,
473471,
452776,
448631,
436991,
434827,
436248,
417280,
412873,
423932,
446367,
434720,
446583,
416538,
415469,
405063,
424881,
435268,
428710,
444704,
417366,
405767,
408228,
419054,
431049,
428661,
422293
],
"UpdateUserTests": [
418881,
409959,
423896,
427648,
426802,
463483,
430061,
418140,
402102,
466995,
444137,
432280,
445688,
442183,
409889,
400856,
416527,
430446,
435789,
448868,
430446,
412113,
422797,
437677,
429075,
420583,
422936,
384714,
410179,
419806
]
},
{
"Context": "Using autoincremented row numbers",
"TestSize": 30,
"SeedCount": 1000,
"AddUserTests": [
196914,
189802,
180146,
189136,
190684,
194919,
205358,
209400,
225133,
226544,
241753,
308494,
283496,
279717,
283852,
297119,
275543,
294473,
316377,
333386,
371606,
348953,
363823,
366546,
362604,
358754,
360026,
391579,
401483,
411406
],
"FindAndUpdateUserTests": [
438285,
432216,
410204,
445447,
415956,
429096,
426264,
440496,
503376,
441266,
441514,
445771,
464467,
439159,
417186,
422979,
456864,
440929,
432054,
437693,
439961,
414000,
428041,
444117,
429560,
432381,
432776,
416631,
416774,
431683
],
"UpdateUserTests": [
438290,
424193,
444503,
425846,
402343,
402077,
434138,
436989,
422164,
433291,
416099,
417641,
520280,
501496,
436882,
427186,
451686,
402341,
412447,
425428,
415398,
426800,
434361,
429154,
419930,
465952,
430641,
427852,
427795,
414332
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, updating all bucket numbers after threshold is passed",
"TestSize": 30,
"SeedCount": 1000,
"AddUserTests": [
41996,
49259,
40521,
42252,
40532,
37285,
36595,
33337,
30922,
31050,
29722,
31232,
31756,
31898,
33032,
29488,
30056,
29246,
29924,
35277,
29238,
30479,
29482,
33395,
30510,
30965,
30900,
30711,
57885,
35801
],
"FindAndUpdateUserTests": [
128909,
113870,
117703,
110283,
134024,
165646,
135106,
132648,
109748,
112865,
131618,
135405,
128105,
154275,
253430,
139115,
144909,
119814,
136716,
137217,
108546,
103837,
109135,
102708,
101884,
101580,
97333,
99237,
103955,
102092
],
"UpdateUserTests": [
91819,
110756,
132123,
146206,
133788,
134593,
113434,
109649,
119984,
129949,
133677,
114955,
115459,
141039,
140121,
121168,
112701,
141400,
142986,
137486,
136757,
117705,
110671,
112655,
135052,
132111,
123168,
120480,
122478,
132145
]
},
{
"Context": "Control: Using no encryption",
"TestSize": 10,
"SeedCount": 10000,
"AddUserTests": [
278577,
206448,
174385,
165496,
194372,
207237,
199415,
152148,
165553,
160702
],
"FindAndUpdateUserTests": [
148854,
165662,
164327,
158193,
157813,
167331,
147906,
154871,
164997,
160583
],
"UpdateUserTests": [
159680,
159779,
161324,
149201,
164890,
152962,
168492,
162118,
144675,
162175
]
},
{
"Context": "Control: using a fixed number of buckets",
"TestSize": 10,
"SeedCount": 10000,
"AddUserTests": [
214900,
215640,
221624,
236195,
210730,
193414,
188687,
190822,
182144,
203957
],
"FindAndUpdateUserTests": [
280998,
279542,
301291,
275507,
276607,
274028,
279442,
278471,
289874,
278356
],
"UpdateUserTests": [
275814,
283821,
279743,
255191,
274058,
287424,
280779,
279666,
285733,
287346
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 10,
"SeedCount": 10000,
"AddUserTests": [
357488,
363565,
356082,
485339,
358854,
350351,
345207,
384420,
408529,
428033
],
"FindAndUpdateUserTests": [
407962,
419061,
424923,
406724,
393219,
406485,
418453,
432844,
426887,
400771
],
"UpdateUserTests": [
403852,
415875,
403588,
414215,
374003,
421161,
438043,
421858,
400825,
415589
]
},
{
"Context": "Using a summary table for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 10,
"SeedCount": 10000,
"AddUserTests": [
369932,
337968,
362122,
366295,
378418,
386342,
397820,
398794,
386804,
377514
],
"FindAndUpdateUserTests": [
494071,
424189,
426278,
425920,
417424,
400655,
386055,
418373,
417980,
421500
],
"UpdateUserTests": [
470320,
456712,
463996,
463328,
380717,
385330,
396687,
487987,
462061,
445446
]
},
{
"Context": "Using autoincremented row numbers",
"TestSize": 10,
"SeedCount": 10000,
"AddUserTests": [
408083,
373667,
390096,
414586,
394803,
427722,
404801,
413769,
412439,
456981
],
"FindAndUpdateUserTests": [
458825,
477154,
453564,
472245,
427412,
452856,
456119,
459961,
467456,
431530
],
"UpdateUserTests": [
473047,
457991,
453517,
470939,
468542,
459105,
462647,
495940,
451720,
448106
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, updating all bucket numbers after threshold is passed",
"TestSize": 10,
"SeedCount": 10000,
"AddUserTests": [
145310,
145582,
142123,
141652,
141104,
140467,
143684,
154171,
140420,
144408
],
"FindAndUpdateUserTests": [
441233,
437012,
444482,
471804,
408957,
404810,
523844,
482229,
452097,
403522
],
"UpdateUserTests": [
491827,
408233,
425133,
408147,
412856,
434277,
437725,
402754,
434313,
433198
]
},
{
"Context": "Control: Using no encryption",
"TestSize": 20,
"SeedCount": 10000,
"AddUserTests": [
237033,
263619,
258860,
260814,
231505,
226066,
222814,
232209,
207031,
200325,
240534,
226503,
233712,
192072,
253704,
328646,
231475,
197795,
249403,
221309
],
"FindAndUpdateUserTests": [
258470,
223335,
194891,
232882,
222916,
223893,
226310,
194111,
249162,
285829,
241413,
351213,
236230,
297999,
296731,
235519,
235453,
197062,
221980,
251509
],
"UpdateUserTests": [
222240,
194764,
250886,
229879,
229136,
196127,
254000,
230447,
245941,
225757,
232315,
195137,
226017,
207375,
265540,
228145,
198478,
217704,
259739,
224837
]
},
{
"Context": "Control: using a fixed number of buckets",
"TestSize": 20,
"SeedCount": 10000,
"AddUserTests": [
295254,
275542,
262960,
258465,
346062,
355486,
313795,
363007,
289071,
279413,
306680,
264795,
281618,
255789,
289837,
262624,
264776,
266853,
264885,
264907
],
"FindAndUpdateUserTests": [
318679,
353492,
350640,
315574,
350320,
350640,
346893,
344128,
374252,
347353,
378369,
358137,
349344,
354270,
353123,
408399,
507859,
408815,
422105,
449614
],
"UpdateUserTests": [
348890,
371931,
355724,
351966,
351573,
346191,
348492,
404169,
350440,
359532,
374109,
347239,
371676,
355956,
343382,
356282,
352365,
354666,
354607,
385141
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 20,
"SeedCount": 10000,
"AddUserTests": [
542845,
527918,
547021,
568702,
461475,
494166,
453530,
464435,
469846,
477145,
503809,
492303,
498441,
488512,
522156,
524545,
527373,
586988,
721345,
582529
],
"FindAndUpdateUserTests": [
641017,
577548,
578086,
587349,
573597,
589196,
555309,
553621,
573120,
577837,
582806,
602749,
569953,
574957,
571613,
689333,
575583,
572916,
571689,
586870
],
"UpdateUserTests": [
586157,
704850,
588264,
597516,
556524,
549306,
577862,
607852,
573033,
570894,
591351,
542364,
696476,
563922,
591406,
612330,
588935,
579628,
547209,
572841
]
},
{
"Context": "Using a summary table for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 20,
"SeedCount": 10000,
"AddUserTests": [
496694,
481554,
458432,
465778,
432873,
450355,
521401,
639188,
549853,
571725,
517472,
507097,
496846,
509583,
546368,
571741,
550490,
551582,
572257,
528604
],
"FindAndUpdateUserTests": [
567469,
562291,
576356,
574467,
656329,
578768,
546520,
662892,
595558,
581967,
562299,
577591,
584959,
561787,
565813,
595744,
558272,
567922,
571355,
551411
],
"UpdateUserTests": [
559748,
686465,
672997,
568497,
600469,
553169,
592033,
568296,
578796,
627027,
572776,
545285,
561993,
601432,
563394,
580036,
581285,
592573,
663350,
667508
]
},
{
"Context": "Using autoincremented row numbers",
"TestSize": 20,
"SeedCount": 10000,
"AddUserTests": [
527806,
495947,
495161,
452155,
489259,
463202,
478968,
484957,
506948,
537280,
546135,
517191,
512140,
535832,
567705,
552257,
568127,
581180,
565811,
607537
],
"FindAndUpdateUserTests": [
696708,
597562,
607319,
619309,
588902,
629805,
605183,
636651,
623951,
617522,
601382,
593421,
617203,
636417,
633931,
703901,
694188,
625739,
601390,
602140
],
"UpdateUserTests": [
597033,
628559,
600428,
631475,
629882,
606151,
633460,
596644,
589913,
602694,
593982,
689053,
725575,
624966,
610032,
597431,
589901,
603427,
609961,
595591
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, updating all bucket numbers after threshold is passed",
"TestSize": 20,
"SeedCount": 10000,
"AddUserTests": [
148497,
147492,
146788,
144356,
141298,
141571,
144537,
142157,
142044,
145689,
141747,
143082,
144479,
140799,
144471,
143009,
144832,
145232,
143068,
139191
],
"FindAndUpdateUserTests": [
398503,
428717,
426820,
469030,
397868,
401153,
411593,
405212,
432713,
406179,
428969,
400971,
432941,
425581,
455612,
488452,
399306,
407058,
426049,
400497
],
"UpdateUserTests": [
434770,
401420,
433653,
412297,
428861,
371386,
401724,
430672,
402821,
382900,
401758,
408212,
428541,
396445,
429265,
432520,
405929,
434607,
405513,
527175
]
},
{
"Context": "Control: Using no encryption",
"TestSize": 30,
"SeedCount": 10000,
"AddUserTests": [
264552,
272534,
196142,
230269,
191957,
230848,
222835,
261669,
222356,
252709,
235855,
255211,
318400,
255062,
367318,
266125,
356341,
239011,
240898,
261988,
253363,
223090,
234337,
191441,
225732,
228432,
229246,
247409,
227029,
253975
],
"FindAndUpdateUserTests": [
230779,
257534,
193222,
240149,
223685,
244755,
220979,
246990,
228882,
192484,
331828,
229977,
247544,
190123,
224900,
230486,
237134,
196656,
227695,
256805,
226704,
195623,
227560,
236117,
254907,
236918,
274988,
319395,
274730,
222801
],
"UpdateUserTests": [
259043,
223784,
227266,
227983,
213684,
240467,
259441,
258558,
267294,
245426,
228350,
196706,
257463,
259312,
255000,
232278,
197798,
230201,
232693,
227206,
230835,
248531,
231612,
226172,
228871,
245764,
250991,
250609,
226662,
233330
]
},
{
"Context": "Control: using a fixed number of buckets",
"TestSize": 30,
"SeedCount": 10000,
"AddUserTests": [
344969,
369587,
280487,
279136,
254199,
327849,
259161,
246521,
254173,
258897,
260942,
259565,
254959,
256604,
255984,
278966,
281153,
281698,
309252,
279221,
284029,
262243,
279053,
257144,
281735,
286790,
256824,
260766,
286691,
280416
],
"FindAndUpdateUserTests": [
333301,
420901,
335661,
425062,
430089,
426252,
373689,
343007,
419829,
333849,
333658,
339943,
365036,
362573,
374191,
338678,
334825,
355100,
334292,
371261,
337689,
367165,
340859,
365587,
323291,
363486,
341169,
357752,
342658,
391103
],
"UpdateUserTests": [
494957,
427864,
340976,
452829,
404169,
363498,
363257,
359768,
362517,
365168,
336336,
333634,
338319,
361474,
364048,
336131,
359817,
338403,
376470,
335447,
339368,
351060,
380106,
342076,
373168,
350884,
451760,
437960,
451747,
427155
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 30,
"SeedCount": 10000,
"AddUserTests": [
433765,
465008,
430723,
428786,
455515,
439768,
451847,
456261,
470261,
490109,
472004,
461131,
495565,
526021,
564359,
563134,
662983,
631393,
521224,
561909,
599338,
583317,
585453,
595202,
631929,
584217,
604464,
628795,
657058,
640531
],
"FindAndUpdateUserTests": [
700521,
776460,
754279,
700200,
685331,
699493,
661320,
647949,
699092,
644498,
686893,
670781,
660828,
642390,
665316,
782730,
687988,
650472,
665095,
690130,
740846,
661343,
676806,
649228,
672671,
691919,
678891,
688776,
645767,
658729
],
"UpdateUserTests": [
716961,
676218,
650350,
650080,
618899,
670102,
648291,
653182,
663665,
649316,
670172,
706561,
671783,
652298,
680640,
675692,
637566,
682552,
643766,
672817,
660208,
663200,
647659,
678155,
647936,
661820,
643096,
678524,
671955,
681097
]
},
{
"Context": "Using a summary table for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 30,
"SeedCount": 10000,
"AddUserTests": [
562666,
413370,
470296,
459721,
477406,
497324,
476293,
511791,
472484,
463331,
495557,
529144,
541629,
544276,
529253,
583104,
592635,
668216,
598979,
589808,
608916,
605436,
581062,
591036,
617280,
631422,
641051,
664304,
643450,
663400
],
"FindAndUpdateUserTests": [
649952,
665703,
716613,
653674,
658532,
652042,
644569,
673851,
636803,
659396,
655111,
671153,
676861,
679650,
631288,
678900,
637159,
717085,
664470,
658903,
640186,
635339,
684289,
654490,
636735,
643000,
679900,
681894,
690491,
646523
],
"UpdateUserTests": [
636066,
666149,
762182,
649559,
656544,
631687,
656728,
676491,
672371,
676688,
685571,
659580,
619270,
636384,
661257,
701869,
698294,
733867,
623102,
644372,
665552,
687373,
634587,
666640,
645550,
677272,
643060,
647790,
631676,
658711
]
},
{
"Context": "Using autoincremented row numbers",
"TestSize": 30,
"SeedCount": 10000,
"AddUserTests": [
473411,
457822,
482259,
485726,
491042,
505936,
533562,
569445,
510327,
495208,
511085,
506862,
532242,
541280,
585775,
553055,
618564,
565550,
591742,
607729,
637514,
634746,
618078,
618641,
615011,
676908,
643936,
690219,
662537,
697401
],
"FindAndUpdateUserTests": [
673603,
687856,
709009,
732749,
706024,
697248,
695141,
684072,
707543,
843192,
722495,
718582,
667671,
703140,
661839,
690294,
671264,
676319,
694324,
688706,
701476,
706174,
671842,
735822,
785910,
692581,
692457,
671852,
693687,
673773
],
"UpdateUserTests": [
683596,
700406,
667365,
695571,
705743,
698814,
681867,
674155,
830182,
710571,
693141,
725471,
671401,
674041,
670134,
698585,
672016,
711959,
675174,
687172,
716115,
705533,
704939,
712502,
687119,
705133,
711468,
700098,
702249,
719745
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, updating all bucket numbers after threshold is passed",
"TestSize": 30,
"SeedCount": 10000,
"AddUserTests": [
146581,
145142,
145545,
145584,
142154,
146218,
145007,
139171,
145237,
145853,
143038,
143317,
135793,
143262,
142973,
139292,
140295,
137361,
143751,
139927,
139092,
144012,
140557,
140612,
140781,
142184,
145430,
139471,
138581,
135978
],
"FindAndUpdateUserTests": [
397351,
428300,
439593,
431984,
437047,
409883,
438770,
429702,
429805,
427245,
439875,
399630,
435915,
403622,
465086,
436040,
531927,
540251,
439490,
407586,
434153,
412302,
410633,
411027,
426285,
439262,
405692,
401057,
403917,
426699
],
"UpdateUserTests": [
420570,
419886,
401619,
397800,
391290,
429099,
468808,
473819,
385939,
401977,
442845,
429954,
433737,
432042,
403487,
403366,
433181,
421322,
394241,
424206,
395359,
418268,
404533,
428491,
420981,
426999,
400878,
400636,
432114,
391531
]
},
{
"Context": "Control: Using no encryption",
"TestSize": 10,
"SeedCount": 100000,
"AddUserTests": [
919421,
896792,
844699,
921934,
850323,
899731,
831369,
797110,
735053,
744649
],
"FindAndUpdateUserTests": [
773428,
745068,
767191,
747316,
785324,
761662,
742172,
736877,
748642,
718319
],
"UpdateUserTests": [
735774,
742567,
751567,
738423,
738935,
730574,
775157,
826330,
746783,
742629
]
},
{
"Context": "Control: using a fixed number of buckets",
"TestSize": 10,
"SeedCount": 100000,
"AddUserTests": [
945817,
916931,
934679,
933130,
901959,
902486,
928632,
912577,
882783,
875813
],
"FindAndUpdateUserTests": [
1719240,
1734223,
1691780,
1675201,
1685144,
1671399,
1772041,
1659708,
1701578,
1644581
],
"UpdateUserTests": [
1630748,
1676241,
1702035,
1656577,
1678496,
1642777,
1677346,
1657296,
1698857,
1665213
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 10,
"SeedCount": 100000,
"AddUserTests": [
1360660,
1290918,
1258620,
1455900,
1249564,
1327156,
1305167,
1244757,
1270278,
1331129
],
"FindAndUpdateUserTests": [
1241636,
1313937,
1331372,
1300749,
1267440,
1300162,
1300327,
1333592,
1330649,
1291240
],
"UpdateUserTests": [
1317637,
1290073,
1344030,
1376478,
1301346,
1268141,
1311524,
1289612,
1342534,
1340750
]
},
{
"Context": "Using a summary table for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 10,
"SeedCount": 100000,
"AddUserTests": [
1390028,
1275296,
1266608,
1223523,
1265026,
1303297,
1219643,
1263274,
1315090,
1242213
],
"FindAndUpdateUserTests": [
1250582,
1248673,
1258583,
1283447,
1262144,
1274505,
1298462,
1246225,
1231688,
1230748
],
"UpdateUserTests": [
1260685,
1246118,
1307353,
1258168,
1312739,
1252563,
1240445,
1339072,
1275715,
1281396
]
},
{
"Context": "Using autoincremented row numbers",
"TestSize": 10,
"SeedCount": 100000,
"AddUserTests": [
1903525,
1779925,
1518949,
1785779,
1602841,
1644235,
1531513,
1694202,
1700648,
1664700
],
"FindAndUpdateUserTests": [
1853271,
1922356,
1839070,
1972204,
1726922,
1658494,
1924619,
1922047,
1614434,
1850811
],
"UpdateUserTests": [
1875805,
1635974,
1776286,
1835272,
1856904,
1620373,
1922867,
1860391,
1686158,
1609941
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, updating all bucket numbers after threshold is passed",
"TestSize": 10,
"SeedCount": 100000,
"AddUserTests": [
1029653,
1063913,
1051285,
1051043,
1056600,
1043047,
1075884,
1053861,
1079466,
1093273
],
"FindAndUpdateUserTests": [
2210119,
2195455,
2245411,
2192961,
2192619,
2240931,
2261365,
2208519,
2199382,
2184369
],
"UpdateUserTests": [
2237993,
2228500,
2212558,
2221784,
2207982,
2349524,
2212264,
2160318,
2170677,
2211956
]
},
{
"Context": "Control: Using no encryption",
"TestSize": 20,
"SeedCount": 100000,
"AddUserTests": [
763871,
727112,
742188,
736266,
740252,
712522,
739263,
732277,
734059,
735172,
736575,
760382,
769613,
758979,
737370,
744871,
740703,
738910,
734348,
744935
],
"FindAndUpdateUserTests": [
734583,
730111,
736487,
728266,
767434,
755193,
721719,
799769,
762712,
741507,
730597,
724681,
748062,
750615,
726254,
738523,
706944,
730906,
741144,
729823
],
"UpdateUserTests": [
721703,
735953,
730597,
727796,
722283,
733606,
737921,
717224,
726252,
724982,
739028,
719921,
752635,
729008,
745791,
723053,
729812,
719733,
733321,
722781
]
},
{
"Context": "Control: using a fixed number of buckets",
"TestSize": 20,
"SeedCount": 100000,
"AddUserTests": [
920104,
903647,
919805,
916558,
903049,
930772,
893846,
921708,
882560,
929607,
958017,
1021257,
949291,
917297,
954549,
902253,
909317,
901251,
952677,
930946
],
"FindAndUpdateUserTests": [
1702434,
1643194,
1687821,
1644802,
1680921,
1704535,
1804306,
1668864,
1671732,
1666674,
1662683,
1648740,
1653074,
1619301,
1650252,
1654153,
1662419,
1670670,
1673617,
1678505
],
"UpdateUserTests": [
1665758,
1674433,
1657027,
1645238,
1666053,
1654329,
1647634,
1631628,
1659951,
1649131,
1685309,
1667023,
1671910,
1660086,
1656695,
1648610,
1661435,
2486489,
1667547,
1636938
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 20,
"SeedCount": 100000,
"AddUserTests": [
1387899,
1224686,
1285027,
1300110,
1276744,
1269434,
1301670,
1247848,
1312603,
1259514,
1287828,
1273909,
1343095,
1326769,
1363010,
1364791,
1374644,
1319410,
1439484,
1405681
],
"FindAndUpdateUserTests": [
1367204,
1424226,
1408846,
1371674,
1345333,
1397714,
1337786,
1382865,
1437416,
1356868,
1437126,
1360802,
1350035,
1369262,
1395396,
1390383,
1395625,
1447019,
1396382,
1389753
],
"UpdateUserTests": [
1378190,
1388008,
1393434,
1402631,
1414688,
1360746,
1704924,
1657785,
1423014,
1421434,
1370479,
1459267,
1431848,
1397570,
1660919,
1643170,
1506424,
1385293,
1370655,
1442740
]
},
{
"Context": "Using a summary table for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 20,
"SeedCount": 100000,
"AddUserTests": [
1312741,
1324025,
1273097,
1331170,
1281368,
1240545,
1261445,
1208925,
1300741,
1253005,
1279384,
1272549,
1284685,
1321260,
1322269,
1293361,
1366890,
1405442,
1297701,
1373061
],
"FindAndUpdateUserTests": [
1317808,
1325126,
1366211,
1336166,
1328968,
1388740,
1317886,
1332538,
1319160,
1300171,
1359668,
1467043,
1352319,
1309256,
1374979,
1297545,
1357450,
1368329,
1335260,
1355539
],
"UpdateUserTests": [
1324122,
1327836,
1335253,
1335884,
1324265,
1614156,
1572804,
1365959,
1626175,
1357411,
1346356,
1372401,
1588885,
1558801,
1589534,
1598799,
1318123,
1607952,
1390300,
1380837
]
},
{
"Context": "Using autoincremented row numbers",
"TestSize": 20,
"SeedCount": 100000,
"AddUserTests": [
1938040,
1495896,
1530929,
1823080,
1863918,
1516759,
1661721,
1810390,
1582049,
1587597,
1903483,
1606502,
1638753,
1884307,
1788809,
1920640,
1907707,
1704676,
1902468,
1633715
],
"FindAndUpdateUserTests": [
1928798,
1706799,
1743040,
1831894,
1930754,
2004495,
1790976,
1963229,
1741102,
1897479,
1983233,
1930899,
1990017,
1702229,
1899515,
1770798,
1735783,
1939213,
1979084,
1680232
],
"UpdateUserTests": [
1937716,
1745848,
1735117,
1959821,
1924845,
1909836,
2004265,
1811478,
1809406,
1699962,
1931296,
1926636,
1943062,
1719976,
1861530,
1945361,
1923180,
1932075,
1916352,
1714617
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, updating all bucket numbers after threshold is passed",
"TestSize": 20,
"SeedCount": 100000,
"AddUserTests": [
1069900,
1072321,
1097464,
1079708,
1092340,
1084890,
1083340,
1043541,
1038061,
1079528,
1054162,
1053956,
1040399,
1051169,
1049413,
1051812,
1038460,
1043997,
1047600,
1045101
],
"FindAndUpdateUserTests": [
2144929,
2309197,
2296804,
2303324,
2179032,
2188025,
2203000,
2179551,
2187701,
2181731,
2159705,
2182793,
2191284,
2191599,
2218704,
2199685,
2177090,
2162551,
2210758,
2238903
],
"UpdateUserTests": [
2214070,
2169453,
2219987,
2161489,
2184964,
2178298,
2170673,
2169208,
2184253,
2171763,
2181439,
2172834,
2195703,
2194453,
2198717,
2231701,
2200611,
2164702,
2203711,
2183038
]
},
{
"Context": "Control: Using no encryption",
"TestSize": 30,
"SeedCount": 100000,
"AddUserTests": [
753598,
753543,
742104,
752708,
782512,
772195,
782640,
745087,
735500,
737143,
748988,
740849,
732671,
727669,
730234,
735700,
730445,
750628,
744913,
746573,
745048,
738513,
737727,
740350,
737086,
735677,
732710,
734756,
731354,
738809
],
"FindAndUpdateUserTests": [
738332,
725870,
732052,
731645,
751716,
746594,
739376,
726314,
731069,
751266,
812896,
732493,
732957,
773640,
726650,
734845,
760128,
741609,
737910,
746540,
739454,
731860,
739386,
736066,
717195,
734829,
757114,
734375,
744126,
759128
],
"UpdateUserTests": [
738594,
729013,
737042,
743327,
742406,
749291,
734503,
733859,
740316,
745597,
765531,
724300,
729023,
741729,
729054,
737670,
740058,
735799,
732457,
743522,
728927,
757127,
740264,
720255,
758281,
743671,
741371,
757789,
734187,
720952
]
},
{
"Context": "Control: using a fixed number of buckets",
"TestSize": 30,
"SeedCount": 100000,
"AddUserTests": [
924464,
895056,
917525,
912955,
929148,
931094,
936211,
909118,
955261,
954409,
979415,
955204,
934555,
914798,
910550,
888210,
905585,
955149,
935567,
944464,
931648,
922432,
922763,
909274,
913560,
904939,
913065,
922020,
918839,
911000
],
"FindAndUpdateUserTests": [
1710054,
1735561,
1715647,
1712950,
2511633,
1677111,
1697136,
1675289,
1685916,
1669528,
1676084,
1701327,
1701339,
1711773,
1668283,
1641764,
1664441,
1722602,
1675973,
1675808,
1659350,
1656883,
1660153,
1697602,
1666857,
1713791,
1638086,
1629296,
1645768,
1720645
],
"UpdateUserTests": [
1758793,
1688701,
2354238,
1655311,
1690476,
1668810,
1675522,
1654547,
1663325,
1672792,
1703563,
1680682,
1664823,
1689154,
1647602,
1653459,
1738939,
1682121,
1682847,
1685918,
1653328,
1681807,
1689056,
1667132,
1649850,
1653464,
1682669,
1680465,
1687412,
1668305
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 30,
"SeedCount": 100000,
"AddUserTests": [
1489776,
1472937,
1556628,
1474189,
1389850,
1382840,
1375135,
1334261,
1311174,
1427842,
1350221,
1425256,
1359196,
1397492,
1432199,
1471673,
2071172,
1577383,
1500116,
1592602,
1732489,
1771209,
1543665,
1610736,
1619616,
1628815,
1641886,
1713335,
1623625,
1580985
],
"FindAndUpdateUserTests": [
1594655,
1638083,
1612916,
1556072,
1871284,
1932592,
1858299,
1772382,
1865216,
1549499,
5237904,
1884428,
1816770,
1600187,
1804694,
1617393,
1864536,
1868598,
2067933,
2146011,
1722819,
1859018,
1707285,
1934553,
1685409,
1739293,
1852793,
2024768,
1788091,
1717121
],
"UpdateUserTests": [
1531988,
1919067,
1631652,
2010491,
1679093,
1683430,
1613296,
1864378,
1947435,
1994076,
1615929,
1885441,
1729058,
1647126,
1847486,
1643260,
1574984,
1534604,
2399829,
1640916,
1836068,
1621930,
1630611,
2019676,
4653954,
1868582,
1612807,
1866078,
1681153,
1912387
]
},
{
"Context": "Using a summary table for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 30,
"SeedCount": 100000,
"AddUserTests": [
1408373,
1297226,
1351080,
1335185,
1390386,
1319566,
1359053,
1347666,
1265146,
1278275,
1422274,
1373832,
1279522,
1337924,
1400896,
1355653,
1330499,
1359149,
2368564,
1420846,
1372980,
1379547,
1400825,
1404188,
1399948,
1465778,
1459342,
1510328,
1544787,
1562740
],
"FindAndUpdateUserTests": [
1463472,
1442528,
1447625,
1516709,
1493016,
1453886,
2541671,
1787033,
1778028,
1453422,
1679111,
1730107,
1402527,
1453013,
1472997,
1690043,
1566324,
1744514,
1443954,
1566340,
1742121,
1438111,
1694713,
1463847,
1460439,
1555753,
1500066,
1722642,
1457617,
1478153
],
"UpdateUserTests": [
1728255,
1764597,
1556861,
1762690,
1478272,
1692745,
1539895,
1469426,
1484144,
1533086,
1753756,
1500008,
1528944,
1811514,
1433951,
1667939,
1426034,
1743091,
2575834,
1710230,
1691855,
1520937,
1765171,
1502993,
1450929,
1759924,
1487496,
1461432,
1491853,
1521915
]
},
{
"Context": "Using autoincremented row numbers",
"TestSize": 30,
"SeedCount": 100000,
"AddUserTests": [
2093130,
1916367,
1954949,
1928748,
2050358,
1876941,
1947054,
1743159,
1636192,
1988000,
1850727,
1873752,
2053476,
2031619,
2055540,
2184530,
1934960,
2074536,
2151211,
1915864,
2139624,
1873169,
2105540,
2130578,
1965231,
2168810,
2023732,
2037724,
2157464,
2289360
],
"FindAndUpdateUserTests": [
1990667,
2290808,
1897982,
2205677,
2020622,
2177581,
2211996,
1914300,
1886302,
2014267,
2168504,
1934716,
1887977,
1912724,
2026573,
2118973,
2128150,
2089086,
2165776,
2057729,
1915350,
2180901,
1894561,
1873168,
2052633,
1899084,
2078164,
2101185,
1827278,
2158606
],
"UpdateUserTests": [
2162381,
1811418,
1895089,
1914206,
2104982,
2164760,
1916879,
2237540,
2243699,
1888181,
2150566,
2127797,
2151895,
2001274,
1870205,
2102912,
1976520,
1919304,
1994850,
2089044,
2198788,
1941740,
2160928,
2006290,
2131194,
2174508,
1911322,
2154827,
2008714,
2147777
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, updating all bucket numbers after threshold is passed",
"TestSize": 30,
"SeedCount": 100000,
"AddUserTests": [
1078759,
1052468,
1043939,
1077651,
1805152,
1072182,
1062384,
1060844,
1095828,
1095053,
1058192,
1071309,
1050967,
1069327,
1071193,
1061586,
1054072,
1057974,
1055528,
1059504,
1060441,
1057394,
1047332,
1052943,
1054839,
1056737,
1049124,
1062874,
1056950,
1055686
],
"FindAndUpdateUserTests": [
2256260,
2228976,
2220598,
2204240,
2189663,
2195124,
2228184,
2205997,
2173301,
2155479,
2179225,
2186297,
2249509,
2197445,
2187278,
2168610,
2204713,
2234718,
2216632,
2177476,
2182666,
2217082,
2182768,
2197642,
2240068,
2201361,
2204914,
2192197,
2213693,
2196160
],
"UpdateUserTests": [
2182609,
2175147,
2207078,
2243453,
2189024,
2279092,
2188022,
2174098,
2202955,
2190477,
2187136,
2204939,
2208682,
2207738,
2205932,
2192300,
2181315,
2234649,
2188282,
2206907,
2185559,
2211374,
2216891,
2168575,
2190485,
2163339,
2234382,
2202092,
2191940,
2189683
]
},
{
"Context": "Control: Using no encryption",
"TestSize": 10,
"SeedCount": 1000000,
"AddUserTests": [
6554289,
6560005,
6446588,
6545852,
6498223,
6813132,
6935391,
6805422,
7070927,
7167681
],
"FindAndUpdateUserTests": [
6749517,
6713827,
6675996,
6759640,
6712013,
6687223,
6733278,
6774619,
6731432,
6748156
],
"UpdateUserTests": [
6733058,
6694947,
6810708,
6847964,
6681679,
6729429,
6728874,
6681205,
6746839,
6701213
]
},
{
"Context": "Control: using a fixed number of buckets",
"TestSize": 10,
"SeedCount": 1000000,
"AddUserTests": [
117401279,
8521144,
8714692,
15245268,
8084167,
11658380,
8185242,
11495766,
8206163,
8156571
],
"FindAndUpdateUserTests": [
15702852,
15477538,
15455403,
15534068,
15330509,
17242727,
15648815,
18636322,
15504049,
15278504
],
"UpdateUserTests": [
15901987,
15405930,
15871552,
15512230,
15576287,
15943582,
15286869,
16225009,
15492694,
15976515
]
},
{
"Context": "Using `SELECT COUNT(*)` for updates to BucketCount, storing BucketExponent in the entity",
"TestSize": 10,
"SeedCount": 1000000,
"AddUserTests": [
76707835,
25435896,
24051210,
14730130,
13358141,
15089452,
14195089,
14664764,
13501334,
13234464
],
"FindAndUpdateUserTests": [
12431911,
14511629,
13474398,
12803638,
13352765,
10361611,
12737059,
11041729,
12916139,
13043249
],
"UpdateUserTests": [
13146210,
16647301,
13333598,
13156157,
13328786,
13282441,
10397142,
13270803,
13256051,
12982361
]
}
]

Add Comment

Please, Sign In to add comment