TSQL Challenge 13 - Load Testing Results



A few solutions that passed the Logic Testing failed in the Load Testing because those solutions used a recursive CTE and did not handle the MAXRECURSION level. Here are the performance statistics of solutions that passed the Load Testing phase of TSQL Challenge 13.

Author Reads Writes CPU Duration Read Rank Write Rank CPU Rank Duration Rank Combined Rank
Jesse Mclain 758350 5 4946 12934987 3 3 3 3 12
Brad Schulz 4988480 0 571743 585243335 7 1 4 4 16
Adan Bucio 4988442 7 576642 593300387 4 4 5 5 18
Randy Derby 4988445 8 664329 678759417 6 5 6 6 23
Steve Howard 4988444 8 727229 744967989 5 5 7 7 24
Leonid Koyfman (1) 6141216 1 822624 1179510136 8 2 9 8 27
Leonid Koyfman (2) 6141216 7 811425 1193001180 8 4 8 9 29