TSQL Challenge 14 - Load Testing Results
Fri, 12/18/2009 - 03:32 — jacob
Here is the list of solutions that passed the Load Testing. The Load Testing was done with a large table with 100,000 rows. 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 (2) | 1035596 | 0 | 9205 | 21 | 5 | 1 | 1 | 1 | 8 |
| Aurelien Verla (1) | 1036200 | 0 | 11950 | 24 | 7 | 1 | 2 | 2 | 12 |
| Aurelien Verla (2) | 604964 | 0 | 32743 | 36 | 1 | 1 | 9 | 7 | 18 |
| Mike Defehr | 1035869 | 0 | 31700 | 31 | 6 | 1 | 7 | 5 | 19 |
| Adam Machanic (2) | 1334600 | 0 | 13058 | 29 | 13 | 1 | 3 | 4 | 21 |
| Rbarry Young (2) | 1356204 | 1917 | 13432 | 24 | 14 | 7 | 4 | 3 | 28 |
| Hodin Matthieu | 998459 | 2127 | 30231 | 37 | 4 | 9 | 6 | 9 | 28 |
| Adan Bucio | 1375390 | 1897 | 14432 | 31 | 15 | 6 | 5 | 6 | 32 |
| Kevin Suchlicki (2) | 1285496 | 1366 | 32338 | 39 | 12 | 3 | 8 | 10 | 33 |
| Jesse Reich | 637560 | 1468 | 133271 | 156 | 2 | 5 | 11 | 15 | 33 |
| Leonid Koyfman | 1555264 | 0 | 34821 | 36 | 17 | 1 | 10 | 8 | 36 |
| Andrew Smith | 1064143 | 1373 | 159650 | 125 | 8 | 4 | 13 | 11 | 36 |
| Syed Mehroz Alam | 1067164 | 2716 | 165952 | 140 | 9 | 11 | 15 | 13 | 48 |
| Chenghui Wang | 740402 | 0 | 461483 | 272 | 3 | 1 | 23 | 22 | 49 |
| Jakob Eskar | 1085594 | 2732 | 178310 | 159 | 11 | 12 | 16 | 16 | 55 |
| Dave Ballantyne | 1075754 | 2732 | 181723 | 193 | 10 | 12 | 17 | 17 | 56 |
| Steve T | 1504478 | 2704 | 208915 | 128 | 16 | 10 | 19 | 12 | 57 |
| Narasimharao Kompella | 3518021 | 8796 | 165516 | 150 | 18 | 14 | 14 | 14 | 60 |
| Fabien Contaminard (1) | 39846671 | 1030 | 196873 | 225 | 21 | 2 | 18 | 19 | 60 |
| Wim Buyens | 6801136 | 5332 | 149511 | 234 | 19 | 13 | 12 | 20 | 64 |
| Regan Wick (2) | 17779636 | 39508 | 256292 | 202 | 20 | 16 | 21 | 18 | 75 |
| Alexandre Dias | 50707933 | 1995 | 269007 | 301 | 23 | 8 | 22 | 23 | 76 |
| Tony Bater | 48324344 | 12850 | 244875 | 257 | 22 | 15 | 20 | 21 | 78 |
A few solutions were rejected at this testing phase due to timeouts. All solutions that took more than 5 minutes to execute were removed from the final results
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
Subscribe
