[Wikidata-bugs] [Maniphest] [Edited] T137972: Use UNION ALL instead of UNION for bulk wbc_entity_usage queries

[jcrespo]

jcrespo edited the task description. (Show Details)

EDIT DETAILS

...

This maybe circumstantial, and not even related, but there is in some cases a slight performance improvement while using `UNION ALL` instead of `UNION`, the first not neededing a temporary table and being able to return rows fasterearlier (without waiting for the full query to finish). Please check that they return the same results, I think they do for this particular case, but technically have different logical meanings, so please double check it.

...

TASK DETAIL

https://phabricator.wikimedia.org/T137972

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: hoo, jcrespo
Cc: daniel, aaron, aude, hoo, Aklapper, Zppix, gerritbot, jcrespo, Vali.matei, D3r1ck01, Izno, Wikidata-bugs, GWicke, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs