|
Size: 838
Comment:
|
Size: 1486
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 7: | Line 7: |
| In the second column, write down the number of results for the query of Exercise 2.<<BR>> In the third column, write down the query time in seconds (with '''exactly two digits of precision''').<<BR>> In the fourth column, write down whether you built an index for your table or not.<<BR>> In the fifth column, give a concise description about the specs of the machine you used.<<BR>> |
In the second column, write down the number of result rows for the query of Exercise 2.<<BR>> In the third column, write down the runtime to process the query, in seconds (with '''exactly two digit of precision''').<<BR>> In the fourth column, write down the memory usage of your program.<<BR>> In the fifth column, write down the number of triples in your wikidata.tsv.<<BR>> In the sixth column, write down whether you built an index for your database table or not.<<BR>> In the seventh column, give a concise description about the specs of the machine you used.<<BR>> In the eighth column, give a concise description about your further improvements in order to speed up the query time.<<BR>> |
| Line 12: | Line 15: |
| ||'''Name''' ||'''#Results'''||'''Time'''||'''With index?'''||'''Processor / RAM'''|| ||ck1028 ||? || 0.??s || ? ||? || |
||'''Name''' ||'''#Result Rows''' ||'''Runtime'''||'''Memory Usage'''||'''#Triples''' ||'''With DB Index?'''||'''Machine Specifications'''||'''Further Improvements''' || ||ck1028 || 10 ||1.80s ||? MB ||48613696 ||yes || ? || None || || ak721-bf87 || 10 || 16.82s || 46 MB || 48613696 || no || Linux 4.14.12, x86_64, 16GB main mem, SSD, i7: 2.70GHz, 2 Cores, 4 Threads || None || |
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 memory usage of your program.
In the fifth column, write down the number of triples in your wikidata.tsv.
In the sixth column, write down whether you built an index for your database table or not.
In the seventh column, give a concise description about the specs of the machine you used.
In the eighth column, give a concise description about your further improvements in order to speed up the query time.
Name |
#Result Rows |
Runtime |
Memory Usage |
#Triples |
With DB Index? |
Machine Specifications |
Further Improvements |
ck1028 |
10 |
1.80s |
? MB |
48613696 |
yes |
? |
None |
ak721-bf87 |
10 |
16.82s |
46 MB |
48613696 |
no |
Linux 4.14.12, x86_64, 16GB main mem, SSD, i7: 2.70GHz, 2 Cores, 4 Threads |
None |