| Nikki added a comment. |
Earlier today abian on IRC mentioned that people are adding redundant P131 statements to get their queries to work.
One of the queries which is failing is this one.
I tried to figure out a way to get it to work and noticed that the selecting by P131 part takes less than a second and the selecting by P31 part takes a few seconds (usually between 2-5), but when I combine them together, it times out. I tried various things like subqueries, filters, turning off optimisation and nothing I tried would make it stop timing out. This makes no sense to me.
After finding this ticket, I tried the approach in the comment above and it can do the original query in a couple of seconds: see here
TASK DETAIL
EMAIL PREFERENCES
To: Smalyshev, Nikki
Cc: Nikki, Jheald, Aklapper, daniel, mschwarzer, Avner, debt, Gehel, D3r1ck01, Jonas, FloNight, Xmlizer, Izno, jkroll, Smalyshev, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331
Cc: Nikki, Jheald, Aklapper, daniel, mschwarzer, Avner, debt, Gehel, D3r1ck01, Jonas, FloNight, Xmlizer, Izno, jkroll, Smalyshev, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
