[Wikidata-bugs] [Maniphest] [Commented On] T152773: COUNT with GROUP BY timing out if used as sub query

2016-12-12 Thread Esc3300 
Esc3300 added a comment.
It's actually surprising that it does work. Maybe when it does, it triggers some VW mode to do the calculation.

Interesting find with the named subquery version.TASK DETAILhttps://phabricator.wikimedia.org/T152773EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Esc3300Cc: Esc3300, Jonas, Smalyshev, Aklapper, hoo, EBjune, mschwarzer, Avner, debt, Gehel, D3r1ck01, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] [Commented On] T152773: COUNT with GROUP BY timing out if used as sub query

2016-12-11 Thread hoo 
hoo added a comment.

In T152773#2863381, @Esc3300 wrote:
I think the problem might be the same as in T152606 : things get slow if ?pred isn't a specific property.


I don't see how they would be related, this query works, unless you make it a subquery.TASK DETAILhttps://phabricator.wikimedia.org/T152773EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: hooCc: Esc3300, Jonas, Smalyshev, Aklapper, hoo, EBjune, mschwarzer, Avner, debt, Gehel, D3r1ck01, FloNight, Xmlizer, Izno, jkroll, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs