[Wikidata-bugs] [Maniphest] [Updated] T166139: Query optimizer for labels should be using sub queries

2018-07-27 Thread Smalyshev
Smalyshev added a project: WDQS-Optimizer. TASK DETAILhttps://phabricator.wikimedia.org/T166139EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: abian, Base, PokestarFan, Smalyshev, Aklapper, Lucas_Werkmeister_WMDE, Jonas, Lahi, Gq86,

[Wikidata-bugs] [Maniphest] [Updated] T166139: Query optimizer for labels should be using sub queries

2017-07-07 Thread Lucas_Werkmeister_WMDE
Lucas_Werkmeister_WMDE added a comment. Strange… I had the impression that named subqueries are typically faster, but in this case it doesn’t seem to make much of a difference. I ran both versions 100 times (P5706), and while regular subqueries have a few slow outliers, overall they seem to