|
Size: 1353
Comment:
|
← Revision 37 as of 2024-02-17 23:17:51 ⇥
Size: 2026
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 12: | Line 12: |
| || lk249 || 6663|| - || - || 103,522 || 3,515|| 1.89|| | || lk249 || 856|| - || - || 103,522 || 3,515|| 0.24|| |
| Line 16: | Line 16: |
| || 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 || |
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 |