|
Size: 752
Comment:
|
Size: 992
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 2: | Line 2: |
| = Results for Exercise Sheet 4 (Operations and query planning) = | = Results for Exercise Sheet 4 (Query planning and joins) = |
| Line 4: | Line 4: |
| ||<tablewidth=""" tableheight=""" tablestyle="" & quot; 909px& amp; quot; ; 949px& amp; quot& quot; ; & amp; quot& quot; ; & amp; quot& quot" ;&quot";&quot"">'''Name''' ||'''3rd fastest sequence (ms)''' ||'''2nd fastest sequence (ms)''' ||'''Fastest sequence (ms)''' ||'''SQLite3 (ms)''' ||'''SQLite3 with indices (ms)''' || '''Fastest / SQLite3 with indices''' || || sw1169 || 3,253 || 563 || 499 || 8,456 || 905 || 0.55 || |
||<tablewidth=""" tableheight=""" tablestyle="" & quot; 909px& amp; quot; ; 949px& amp; quot& quot; ; & amp; quot& quot; ; & amp; quot& quot" ;&quot";&quot"">'''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 || |
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 |