Différences entre les versions de « Issue/2073 »
De Semantic MediaWiki - Sandbox
(→Query) |
|||
Ligne 84 : | Ligne 84 : | ||
|limit=2 | |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 | ||
+ | }} | ||
+ | |||
+ | {{#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 | ||
+ | }} | ||
{{#scite:gh:smw:2061 | {{#scite:gh:smw:2061 |
Version du 4 décembre 2016 à 15:08
Property:Runtime benchmark, Template:Runtime benchmark
Data
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 }}
Runtime benchmark | Memory used⠉ | ID⠉ | Runtime⠉ | Benchmark notes⠉ | |
---|---|---|---|---|---|
Issue/2073 | 27 novembre 2016 | 16597192 | 200 | 47,12 | n/a |
Issue/2073 | 27 novembre 2016 | 16680696 | 200 | 47,18 | n/a |
... autres résultats |
{{#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 }}
Runtime benchmark | Memory used⠉ | ID⠉ | Runtime⠉ | Benchmark notes⠉ | |
---|---|---|---|---|---|
Issue/2073 | 27 novembre 2016 | 16597192 | 200 | 47,12 | n/a |
Issue/2073 | 27 novembre 2016 | 16680696 | 200 | 47,18 | n/a |
... autres résultats |
Chain sort/order
Runtime benchmark | Memory used⠉ | ID⠉ | Runtime⠉ | Benchmark notes⠉ | |
---|---|---|---|---|---|
Issue/2073 | 27 novembre 2016 | 16597192 | 200 | 47,12 | n/a |
Issue/2073 | 27 novembre 2016 | 16680696 | 200 | 47,18 | n/a |
Issue/2073 | 27 novembre 2016 | 16690400 | 200 | 48,35 | n/a |
Issue/2073 | 27 novembre 2016 | 19383544 | 4 475 | 410,13 | n/a |
Runtime benchmark | Memory used⠉ | ID⠉ | Runtime⠉ | Benchmark notes⠉ | |
---|---|---|---|---|---|
Issue/2073 | 27 novembre 2016 | 16597192 | 200 | 47,12 | n/a |
Issue/2073 | 27 novembre 2016 | 16680696 | 200 | 47,18 | n/a |
Issue/2073 | 27 novembre 2016 | 16690400 | 200 | 48,35 | n/a |
Issue/2073 | 27 novembre 2016 | 19383544 | 4 475 | 410,13 | n/a |
Runtime benchmark | Memory used⠉ | ID⠉ | Runtime⠉ | Benchmark notes⠉ | |
---|---|---|---|---|---|
Issue/2073 | 27 novembre 2016 | 19383544 | 4 475 | 410,13 | n/a |
Issue/2073 | 27 novembre 2016 | 16690400 | 200 | 48,35 | n/a |
Issue/2073 | 27 novembre 2016 | 16680696 | 200 | 47,18 | n/a |
Issue/2073 | 27 novembre 2016 | 16597192 | 200 | 47,12 | n/a |
Runtime benchmark | Memory used⠉ | ID⠉ | Runtime⠉ | Benchmark notes⠉ | |
---|---|---|---|---|---|
Issue/2073 | 27 novembre 2016 | 19383544 | 4 475 | 410,13 | n/a |
Issue/2073 | 27 novembre 2016 | 16690400 | 200 | 48,35 | n/a |
Issue/2073 | 27 novembre 2016 | 16680696 | 200 | 47,18 | n/a |
Issue/2073 | 27 novembre 2016 | 16597192 | 200 | 47,12 | n/a |
Debug outputElasticStore{ "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}) #*:*" } ] } ] }