Différences entre les versions de « Issue/2073 »

De Semantic MediaWiki - Sandbox
(linkfix)
 
(8 versions intermédiaires par 2 utilisateurs non affichées)
Ligne 1 : Ligne 1 :
−
Relates to #2061[[CiteRef::gh:smw:2061]][[CiteRef::gh:smw:1824]]
+
Relates to #2073[[CiteRef::gh:smw:2073]][[CiteRef::gh:smw:1824]]
  
 
[[Property:Runtime benchmark]], [[Template:Runtime benchmark]]
 
[[Property:Runtime benchmark]], [[Template:Runtime benchmark]]
  
 
== Data ==
 
== Data ==
 +
<pre>
 +
{{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
 +
}}
 +
</pre>
 
{{Runtime benchmark
 
{{Runtime benchmark
 
  |date=27 Nov 2016
 
  |date=27 Nov 2016
Ligne 36 : Ligne 67 :
 
== Query ==
 
== Query ==
 
=== Standard select ===
 
=== Standard select ===
−
 
+
<pre>
−
{{#ask: [[Issue/2073::+]] [[Runtime benchmark.ID::+]]
+
{{#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
 +
}}
 +
</pre>
 +
{{#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
 +
}}
 +
<pre>
 +
{{#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
 +
}}
 +
</pre>
 +
{{#ask: [[Runtime benchmark.ID::+]]
 
  |?Runtime benchmark
 
  |?Runtime benchmark
 
  |?Runtime benchmark.Memory used#-
 
  |?Runtime benchmark.Memory used#-
Ligne 49 : Ligne 116 :
 
}}  
 
}}  
  
−
{{#scite:gh:smw:2061
+
=== Chain sort/order ===
 +
<pre>
 +
{{#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
 +
}}
 +
</pre>
 +
{{#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
 +
}}
 +
 
 +
<pre>
 +
{{#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
 +
}}
 +
</pre>
 +
{{#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
 +
}}
 +
 
 +
<pre>
 +
{{#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
 +
}}
 +
</pre>
 +
{{#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
 +
}}
 +
 
 +
<pre>
 +
{{#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
 +
}}
 +
</pre>
 +
{{#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 ==
 +
<pre>
 +
{{#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
 +
}}
 +
</pre>
 +
{{#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:2073
 
  |type=issue
 
  |type=issue
−
  |citation text=https://github.com/SemanticMediaWiki/SemanticMediaWiki/issue/2061
+
  |citation text=https://github.com/SemanticMediaWiki/SemanticMediaWiki/pull/2073
 
}}
 
}}
  
−
[[Category:Issue]]
+
[[Category:Issue]] {{interlanguagelink:en|Issue/2073}}

Dernière version du 20 novembre 2018 à 11:40

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
}}
 Runtime benchmarkMemory used⠉ID⠉Runtime⠉Benchmark notes⠉
Issue/207327 novembre 20161659719220047.12n/a
Issue/207327 novembre 20161668069620047.18n/a
... further results
{{#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 benchmarkMemory used⠉ID⠉Runtime⠉Benchmark notes⠉
Issue/207327 novembre 20161659719220047.12n/a
Issue/207327 novembre 20161668069620047.18n/a
... further results

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
}}
 Runtime benchmarkMemory used⠉ID⠉Runtime⠉Benchmark notes⠉
Issue/207327 novembre 20161659719220047.12n/a
Issue/207327 novembre 20161668069620047.18n/a
Issue/207327 novembre 20161669040020048.35n/a
Issue/207327 novembre 2016193835444,475410.13n/a
{{#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
}}
 Runtime benchmarkMemory used⠉ID⠉Runtime⠉Benchmark notes⠉
Issue/207327 novembre 20161659719220047.12n/a
Issue/207327 novembre 20161668069620047.18n/a
Issue/207327 novembre 20161669040020048.35n/a
Issue/207327 novembre 2016193835444,475410.13n/a
{{#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
}}
 Runtime benchmarkMemory used⠉ID⠉Runtime⠉Benchmark notes⠉
Issue/207327 novembre 2016193835444,475410.13n/a
Issue/207327 novembre 20161669040020048.35n/a
Issue/207327 novembre 20161668069620047.18n/a
Issue/207327 novembre 20161659719220047.12n/a
{{#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
}}
 Runtime benchmarkMemory used⠉ID⠉Runtime⠉Benchmark notes⠉
Issue/207327 novembre 2016193835444,475410.13n/a
Issue/207327 novembre 20161669040020048.35n/a
Issue/207327 novembre 20161668069620047.18n/a
Issue/207327 novembre 20161659719220047.12n/a

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_",
                "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}) #*:*"
                }
            ]
        }
    ]
}

Références

  1. ^  https://github.com/SemanticMediaWiki/SemanticMediaWiki/issue/2061
  2. ^  https://github.com/SemanticMediaWiki/SemanticMediaWiki/pull/1824

Récupérée de « https://sandbox.semantic-mediawiki.net/w/index.php?title=Issue/2073&oldid=12913 »
Les cookies nous aident à fournir nos services. En utilisant nos services, vous acceptez notre utilisation de cookies.
Davantage d’informations