Comment 3 for bug 421901

I've updated the query in the description; its basically insane.

First union is 'bugs this user is the assignee'
Second is 'this user is directly subscribed'
Third is 'this user created the bug and created the bugtask'
Fourth is a poorly phrased 'user commented on the bug' - poorly phrased because the inner query does more work than needed - it only needs to bring back the bug; the outer query can use bugtask.bug to filter on.

I'm not sure whether the four unions are needed or not; I'd break it down and time each separately; if possible optimise, and then look at a combined story. E.g. combining assignee and owner queries is probably basic sense.