| Lucas_Werkmeister_WMDE reopened this task as "Open". Lucas_Werkmeister_WMDE added a comment. |
I think there must be a misunderstanding here… it’s not clear whether a named subquery or a non-named subquery is faster, but there is a very definitive performance improvement in adding the (named or regular) subquery over the unoptimized query. You yourself wrote:
the first query form resolves 44326 labels, 23178 of them unique, even though it only needs 100 in the second form.
The point of this issue is to defer label service execution until the results have already been found without the label service, unless that’s not possible (e. g. because the labels are used in a HAVING clause, or in an ORDER BY clause where there is also a LIMIT).
TASK DETAIL
EMAIL PREFERENCES
To: Lucas_Werkmeister_WMDE
Cc: PokestarFan, Smalyshev, Aklapper, Lucas_Werkmeister_WMDE, Jonas, GoranSMilovanovic, QZanden, EBjune, merbst, Avner, debt, Gehel, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
Cc: PokestarFan, Smalyshev, Aklapper, Lucas_Werkmeister_WMDE, Jonas, GoranSMilovanovic, QZanden, EBjune, merbst, Avner, debt, Gehel, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
