Home

TSQL Challenge 23 - Performance Testing Results


Here is the list of solutions that passed the Load Testing. Here is the script used to generate the test data.

Author Reads Writes CPU Duration (Sec) Read Rank Write Rank CPU Rank Duration Rank Combined Rank
mark cowne 93 0 118 0.2262 1 1 2 2 6
Dalibor Margotic 193 0 105 0.2494 6 1 1 3 11
Adan Bucio 128 0 121 0.2982 4 1 3 6 14
parth patel 127 0 159 0.2810 3 1 7 5 16
gustavo gonzalez 238 0 140 0.2186 8 1 6 1 16
Rami reddy 124 0 171 0.3004 2 1 8 7 18
Mueller Lutz 271 0 127 0.2518 9 1 4 4 18
rubeshnee padayachee 238 0 137 0.3204 8 1 5 9 23
dave repton 180 0 212 0.3436 5 1 11 10 27
Pragnesh Patel 361 0 199 0.3068 10 1 10 8 29
Muhammad Pasha 228 0 230 0.3620 7 1 12 12 32
Michael Lewis 589 4 174 0.3456 11 3 9 11 34
tomas boixet 6477 0 1775 1.8977 12 1 14 14 41
erik eckhardt 540127 1 1001 1.0943 22 2 13 13 50
erick bailey 134791 17 6514 6.5984 16 7 15 15 53
leszek g 119634 15 6577 6.6458 13 5 19 17 54
erick bailey 134791 17 6518 6.6238 16 7 16 16 55
erick bailey 134733 16 6543 6.6514 15 6 17 18 56
leszek g 119635 14 6614 6.7200 14 4 20 20 58
erick bailey 134733 17 6564 6.6626 15 7 18 19 59
erick bailey 134969 17 6661 6.7248 18 7 21 21 67
erick bailey 134911 17 6667 6.7850 17 7 22 22 68
erick bailey 134911 17 6742 6.8196 17 7 23 23 70
spark s 240782 28 15687 15.8381 20 8 24 24 76
spark s 240360 28 15893 16.0399 19 8 25 25 77
spark s 480327 49 28791 28.9513 21 9 26 26 82
meierruth michael 1869967 163 114698 114.8856 23 10 27 27 87

Note that the challenges are 'always ON', which means that you can submit a solution at any time. You can submit a new solution even after the results are published. If your solution is disqualified due to one of the reasons given above, you can re-submit a new version of the challenge at any time.

Never submitted a solution? Or got a new/different version? Submit it