Relates to #207312
Property:Runtime benchmark, Template:Runtime benchmark
Data
{{Runtime benchmark
|date=27 Nov 2016
|version=0583b05
|memory=16690400
|runtime=48.35
|notes=n/a
|id=200
}}{{Runtime benchmark
|date=27 Nov 2016
|version=0583b05
|memory=19383544
|runtime=410.13
|notes=n/a
|id=4475
}}{{Runtime benchmark
|date=27 Nov 2016
|version=0583b05
|memory=16597192
|runtime=47.12
|notes=n/a
|id=200
}}{{Runtime benchmark
|date=27 Nov 2016
|version=0583b05
|memory=16680696
|runtime= 47.18
|notes=n/a
|id=200
}}
Query
Standard select
{{#ask: [[Runtime benchmark.ID::+]]
|?Runtime benchmark
|?Runtime benchmark.Memory used#-
|?Runtime benchmark.ID
|?Runtime benchmark.Runtime
|?Runtime benchmark.Benchmark notes
|format=broadtable
|sort=ID
|order=desc
|limit=2
}}
{{#ask: [[Runtime benchmark.ID::+]]
|?Runtime benchmark
|?Runtime benchmark.Memory used#-
|?Runtime benchmark.ID
|?Runtime benchmark.Runtime
|?Runtime benchmark.Benchmark notes
|format=broadtable
|sort=ID
|order=asc
|limit=2
}}
Chain sort/order
{{#ask: [[Runtime benchmark.ID::+]]
|?Runtime benchmark
|?Runtime benchmark.Memory used#-
|?Runtime benchmark.ID
|?Runtime benchmark.Runtime
|?Runtime benchmark.Benchmark notes
|format=broadtable
|sort=Runtime benchmark.ID,Runtime benchmark.Runtime
|order=asc,desc
|limit=20
}}
{{#ask: [[Runtime benchmark.ID::+]]
|?Runtime benchmark
|?Runtime benchmark.Memory used#-
|?Runtime benchmark.ID
|?Runtime benchmark.Runtime
|?Runtime benchmark.Benchmark notes
|format=broadtable
|sort=Runtime benchmark.ID,Runtime benchmark.Runtime
|order=asc,asc
|limit=20
}}
{{#ask: [[Runtime benchmark.ID::+]]
|?Runtime benchmark
|?Runtime benchmark.Memory used#-
|?Runtime benchmark.ID
|?Runtime benchmark.Runtime
|?Runtime benchmark.Benchmark notes
|format=broadtable
|sort=Runtime benchmark.ID,Runtime benchmark.Runtime
|order=desc,asc
|limit=20
}}
{{#ask: [[Runtime benchmark.ID::+]]
|?Runtime benchmark
|?Runtime benchmark.Memory used#-
|?Runtime benchmark.ID
|?Runtime benchmark.Runtime
|?Runtime benchmark.Benchmark notes
|format=broadtable
|sort=Runtime benchmark.ID,Runtime benchmark.Runtime
|order=desc,desc
|limit=20
}}
Debug
{{#ask: [[Runtime benchmark.ID::+]]
|?Runtime benchmark
|?Runtime benchmark.Memory used#-
|?Runtime benchmark.ID
|?Runtime benchmark.Runtime
|?Runtime benchmark.Benchmark notes
|format=debug
|sort=Runtime benchmark.ID,Runtime benchmark.Runtime
|order=asc,desc
|limit=2
}}
{
"smw": {
"query": "[[Runtime benchmark.ID::+]]",
"sort": {
"Runtime_benchmark.ID": "ASC",
"Runtime_benchmark.Runtime": "DESC"
},
"metrics": {
"query size": 2,
"query depth": 2
},
"description_log": [
[
{
"SomeProperty": {
"Chain": "[[ID::+]]"
}
}
]
]
},
"elastic": [
{
"chain_lookup_query": [
"ID",
"[[ID::+]]"
],
"query": {
"index": "smw-data-db9910120150926-02100_",
"type": "data",
"body": {
"_source": false,
"query": {
"constant_score": {
"filter": {
"bool": {
"must": {
"bool": {
"filter": {
"exists": {
"field": "P:5903.numField"
}
}
}
}
}
}
}
}
},
"size": 10000
},
"search_info": {
"took": 2,
"timed_out": false,
"max_score": 1,
"total": 9
},
"isFromCache": false
},
{
"index": "smw-data-db9910120150926-02100_",
"type": "data",
"body": {
"_source": false,
"from": 0,
"size": 3,
"query": {
"constant_score": {
"filter": {
"bool": {
"must": {
"terms": {
"P:5900.wpgID": [
13312,
13336,
13376,
13392,
247660,
247659,
247661,
247662,
20934
]
}
}
}
}
}
},
"sort": [
{
"P:5900.wpgField.sort": {
"order": "asc"
},
"P:5903.numField": {
"order": "asc"
},
"P:5902.numField": {
"order": "desc"
}
}
]
}
},
{
"_shards": {
"total": 1,
"successful": 1,
"failed": 0
},
"valid": true,
"explanations": [
{
"index": "smw-data-db9910120150926-02100_-v2",
"valid": true,
"explanation": "+ConstantScore(+P:5900.wpgID:{13312 13336 13376 13392 20934 247659 247660 247661 247662}) #*:*"
}
]
}
]
}