Home

TSQL Challenge 22 - 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
carlos benito 52088 11 224 0.3120 5 1 1 1 8
Jesse Roberge 52235 14 252 0.3336 6 3 2 2 13
Robert Little 41599 17 271 0.3744 3 5 3 3 14
gustavo gonzalez 52346 14 312 0.3876 7 3 6 4 20
Jesse Roberge 41412 34 277 0.4254 2 10 4 5 21
Kevin Kershaw 126029 13 408 0.5156 9 2 9 6 26
bret warnick 41645 40 331 0.5550 4 12 7 8 31
jeff schwartzmann 33137 75 309 0.5396 1 19 5 7 32
tom cooper 154021 43 480 0.6658 11 13 11 9 44
tom cooper 153944 54 474 0.7044 10 17 10 10 47
jmc bkk 478528 19 1279 1.3999 16 6 13 13 48
Michael Lewis 67485 122 371 0.7278 8 22 8 11 49
Nilay Chaudhari 206876 15 7257 7.3756 12 4 17 17 50
jimbob mcgee 285306 30 5363 5.5437 13 7 16 16 52
leigh waldie 440481 95 1048 1.2775 14 21 12 12 59
spark s 643734 34 12689 12.8659 19 10 18 18 65
Ruchay Sohawan 578634 86 1622 1.8435 17 20 15 15 67
binns len 444721 37 30941 31.3308 15 11 21 21 68
steve p 637406 156 1553 1.7065 18 25 14 14 71
STEPHEN MUNSON 1002200 13 71526 72.0033 21 2 25 25 73
leonid koyfman 1079654 15 75245 75.7211 22 4 26 26 78
Pragnesh Patel 1251924 30 51183 51.5567 23 7 24 24 78
erick Bailey 11442796 33 18557 18.8111 32 9 19 19 79
leszek gniadkowski 1783377 31 40373 40.7025 27 8 23 23 81
Gyan Koju 1289307 14 83610 84.1288 25 3 27 27 82
Pavel Krticka 949249 133 27908 28.4008 20 24 20 20 84
leszek gniadkowski 1262026 158 31559 31.8562 24 26 22 22 94
fernando ortega 1430933 66 92914 93.6156 26 18 28 28 100
Pragnesh Patel 2069954 46 127783 128.5458 28 14 29 29 100
Pragnesh Patel 2127108 49 138285 139.1858 29 15 30 30 104
Pragnesh Patel 2856149 53 185404 186.4951 31 16 32 32 111
leszek gniadkowski 2748660 127 169208 170.2707 30 23 31 31 115

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