|
Size: 1440
Comment:
|
Size: 2084
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 9: | Line 9: |
| ||tv68 || 21 || 17.661s || 30,856,615 || yes || AMD Ryzen 5 1600X CPU @ 3.60GHz; 16 GB RAM (but VM is only allowed to use 4 cores and 8 GB RAM); HDD || ANALYZE on table || | ||tv68 || 21 || 17.661s || 30,855,696 || yes || AMD Ryzen 5 1600X CPU @ 3.60GHz; 16 GB RAM (but VM is only allowed to use 4 cores and 8 GB RAM); HDD || ANALYZE on table || ||cg278 || 21 || 7.57s || 30,855,696 || no || Apple M1 @ 3.20GHz, 16GB RAM; SSD || ANALYZE on table || ||rw159 || 21 ||1.80s ||30,855,696 ||yes ||Intel i5-10210U @ 1.60GHz; 32GB RAM; SSD || ANALYZE on table ||ANALYZE on table || ||kd147 || 21 || 8.795s || 30,855,696 || no || Intel i7-1165G7, 16GB RAM; SSD || - || ||ps541 || 21 ||0.343s ||30,855,696 ||yes ||Intel i5-10 8GB RAM, MAC || ANALYZE on table || ||ad414 || 21 || 1.01s || 30,855,696 ||yes ||Intel i7-10750H @ 2.60GHz; 8GB RAM; SSD || ANALYZE on table || ||ba102 || 21 || 8.29s || 30,855,696 ||no ||11th Gen Intel(R) Core(TM) i7-1185G7 @ 3.00GHz; 16GB RAM; SSD || Look above || |
Results for Exercise Sheet 12 (SPARQL)
Click "Edit (Text)" 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 down your account name, or name1+name2 if you work in a group.
In the second column, write down the number of result rows for the query of Exercise 2.
In the third column, write down the runtime to process the query, in seconds (with exactly two digit of precision).
In the fourth column, write down the number of triples in your wikidata.tsv.
In the fifth column, write down whether you built an index for your database table or not.
In the sixth column, give a concise description about the specs of the machine you used.
In the seventh column, give a concise description about your further improvements in order to speed up the query time.
Name |
#Result Rows |
Runtime |
#Triples |
With DB Index? |
Machine Specifications |
Further Improvements |
|
pb1042 |
21 |
0.12s |
30,855,696 |
yes |
Intel i5-5 @ 2.00GHz; 32GB RAM; SSD |
ANALYZE on table |
|
mr716 |
21 |
0.082s |
30,856,615 |
yes |
Inter i7-7 ; 8GB RAM; SSD |
ANALYZE on table |
|
tv68 |
21 |
17.661s |
30,855,696 |
yes |
AMD Ryzen 5 1600X CPU @ 3.60GHz; 16 GB RAM (but VM is only allowed to use 4 cores and 8 GB RAM); HDD |
ANALYZE on table |
|
cg278 |
21 |
7.57s |
30,855,696 |
no |
Apple M1 @ 3.20GHz, 16GB RAM; SSD |
ANALYZE on table |
|
rw159 |
21 |
1.80s |
30,855,696 |
yes |
Intel i5-10210U @ 1.60GHz; 32GB RAM; SSD |
ANALYZE on table |
ANALYZE on table |
kd147 |
21 |
8.795s |
30,855,696 |
no |
Intel i7-1165G7, 16GB RAM; SSD |
- |
|
ps541 |
21 |
0.343s |
30,855,696 |
yes |
Intel i5-10 8GB RAM, MAC |
ANALYZE on table |
|
ad414 |
21 |
1.01s |
30,855,696 |
yes |
Intel i7-10750H @ 2.60GHz; 8GB RAM; SSD |
ANALYZE on table |
|
ba102 |
21 |
8.29s |
30,855,696 |
no |
11th Gen Intel(R) Core(TM) i7-1185G7 @ 3.00GHz; 16GB RAM; SSD |
Look above |