/participants API timing out

Fixed in stable r11298 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/11298>.

Fixed in stable r11305 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/11305>.

Removed the qa-needstesting tag - this hasn't landed yet !

Ok, so a newer fix *has* landed, but a related (possibly key) issue makes it take 6 seconds to count(*) - it will probably be Just Fine on production, but a tweak to the query takes it down to 30ms, so I'm going to go ahead and do that.

SELECT COUNT(*) FROM Person JOIN TeamParticipation ON TeamParticipation.person = Person.id LEFT JOIN KarmaTotalCache ON KarmaTotalCache.person = Person.id LEFT JOIN PersonLocation ON PersonLocation.person = Person.id LEFT JOIN Archive ON Archive.owner = Person.id LEFT JOIN EmailAddress ON EmailAddress.person = Person.id LEFT JOIN account on person.account=account.id WHERE TeamParticipation.team = 238131 AND NOT (TeamParticipation.person = 238131) AND (Archive.id IS NULL OR Archive.id = (SELECT MIN(Archive.id) FROM Archive WHERE Archive.owner = Person.id) AND Archive.purpose = 2) AND (EmailAddress.status IS NULL OR (EmailAddress.status = 4 AND (account.status is NULL or account.status=20)));

New query tried out on staging (via losa help) - first batch is completely delivered in 3.5seconds to .au, so I'm proposing that to merge.

Fixed in stable r11367 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/11367>.

naughty bot :)

@lifeless If you don't want the bot to touch the bug, you should mark it as incremental! :) ec2 land --incremental or add [incr] tag to the commit msg manually; should do the trick.

On Thu, Aug 19, 2010 at 3:24 AM, Ursula Junque <email address hidden> wrote:
> @lifeless If you don't want the bot to touch the bug, you should mark it
> as incremental! :) ec2 land --incremental or add [incr] tag to the
> commit msg manually; should do the trick.

Yeah, problem is that:
 - the previous commit was *thought* to fix it [so arguably qa-bad], but
 - it didn't make it worse [so really just neutral]

:)

r11389 in stable (http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/11389) is part of this bug's fix.

Fixed in stable r11544 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/11544>.

Fixed in stable r11573 <http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/11573>.