jcrespo added a comment.

I conclude that we should run one query per term type here and simply merge the result in the application code.

Yes, this is a property of Btree indexes- 2 ranges cannot be handled efficiently- you can only handle one with an index at a time. You could even merge both into UNION ALLs, but again, as usual, I suggest going for the largest gain ASAP.


TASK DETAIL
https://phabricator.wikimedia.org/T147748

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

To: jcrespo
Cc: gerritbot, Stashbot, hoo, MZMcBride, TerraCodes, Luke081515, Jay8g, Aklapper, jcrespo, Lewizho99, Maathavan, D3r1ck01, Izno, Wikidata-bugs, aude, Mbch331, Krenair
_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Reply via email to