Issue/2073

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
}}

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_",
                "body": {
                    "_source": false,
                    "query": {
                        "constant_score": {
                            "filter": {
                                "bool": {
                                    "must": {
                                        "bool": {
                                            "filter": {
                                                "exists": {
                                                    "field": "P:5903.numField"
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                },
                "size": 10000
            },
            "search_info": {
                "took": 3,
                "timed_out": false,
                "max_score": 1,
                "total": 5
            },
            "isFromCache": false
        },
        {
            "index": "smw-data-db9910120150926-02100_",
            "body": {
                "_source": false,
                "from": 0,
                "size": 3,
                "query": {
                    "constant_score": {
                        "filter": {
                            "bool": {
                                "must": {
                                    "terms": {
                                        "P:5900.wpgID": [
                                            13312,
                                            13376,
                                            13392,
                                            20934,
                                            13336
                                        ]
                                    }
                                }
                            }
                        }
                    }
                },
                "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_-v1",
                    "valid": true,
                    "explanation": "ConstantScore(+P:5900.wpgID:{13312 13336 13376 13392 20934})"
                }
            ]
        }
    ]
}