Results for Exercise Sheet 4 (Query planning and joins)
Click "Edit" in the upper bar of this page and add your row to the table below, following the examples already there. In the first column, write your account name.
Name |
3rd fastest sequence (ms) |
2nd fastest sequence (ms) |
Fastest sequence (ms) |
SQLite3 (ms) |
SQLite3 with indices (ms) |
Fastest sequence / SQLite3 with indices |
sw1169 |
748 |
435 |
429 |
8,361 |
860 |
0.50 |
pw194 |
5490 |
730 |
454 |
15,303 |
887 |
0.51 |
ft136 |
6824 |
2043 |
216 |
17,863 |
941 |
0.23 |
jg515 |
1647 |
879 |
417 |
31,879 |
1,742 |
0.24 |
nv78 |
4,194 |
2,821 |
356 |
13,715 |
692 |
0.51 |
md480 |
466 |
334 |
292 |
17,560 |
1,310 |
0.22 |
lf321 |
1391 |
937 |
816 |
37,140 |
2,015 |
0.40 |
lk249 |
856 |
- |
- |
103,522 |
3,515 |
0.24 |
rn79 |
1371 |
762 |
672 |
47,042 |
2,482 |
0.27 |
nm208 |
6,973 |
519 |
434 |
20,481 |
1,352 |
0.32 |
mv237 |
1,409 |
798 |
534 |
17,094 |
1,056 |
0.51 |
os141 |
867 |
840 |
599 |
13,940 |
731 |
0.82 |
jk867 |
908 |
579 |
429 |
19,817 |
1,007 |
0.43 |
ap369 |
4111 |
507 |
419 |
28,09 |
1,581 |
0,26 |
aa272 |
887 |
324 |
309 |
16,077 |
1,041 |
0.29 |
ak1353 |
8,157 |
725 |
697 |
25,777 |
1,174 |
0.59 |
mg709 |
5238 |
4797 |
247 |
50,255 |
1,780 |
0.14 |
ag696 |
3,495 |
744 |
625 |
18,569 |
1,001 |
0.80 |
jb1319 |
1393 |
709 |
703 |
13085 |
1259 |
0.558 |
li48 |
872 |
- |
747 |
24460 |
1448 |
0.515 |
mm812 |
6,567 |
5,101 |
721 |
19,875 |
1,016 |
0.71 |
jk1308 |
595 |
529 |
509 |
15415 |
855 |
0.50 |