[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

[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