TeamMembership:TeamInvitationView can timeout (3000+ statements) accepting team invitation

[Diogo Matsubara]

As seen in OOPS-1274ED146 the page to accept team membership times out (>3000 statements count) when accepting big teams

This might be fixed by the (not yet implemented) infrastructure described in https://blueprints.edge.launchpad.net/launchpad-registry/+spec/efficient-user-sets

SQL time: 6450 ms
Non-sql time: 7693 ms
Total time: 14143 ms
Statement Count: 3257

1 1079 1629 1 1628 SELECT TeamParticipation.id, TeamParticipation.person, TeamParticipation.team FROM TeamParticipation WHERE TeamParticipation.person = %s AND TeamParticipation.team = %s
2 1075 2673 2 2671 SELECT Person.account, Person.addressline1, Person.addressline2, Person.city, Person.country, Person.creation_comment, Person.creation_rationale, Person.datecreated, Person.defaultmembershipperiod, Person.defaultrenewalperiod, Person.displayname, Person.hide_email_addresses, Person.homepage_content, Person.icon, Person.id, Person.logo, Person.mailing_list_auto_subscribe_policy, Person.merged, Person.mugshot, Person.name, Person.organization, Person.personal_standing, Person.personal_standing_reason, Person.phone, Person.postcode, Person.province, Person.registrant, Person.renewal_policy, Person.subscriptionpolicy, Person.teamdescription, Person.teamowner, Person.verbose_bugnotifications, Person.visibility FROM Person, TeamParticipation WHERE Person.id = TeamParticipation.team AND TeamParticipation.person = 2968414 AND TeamParticipation.team != 2968414 AND (1=1) ORDER BY person_sort_key(Person.displayname, Person.name)
3 1041 1855 1 1854 INSERT INTO TeamParticipation (person, team) VALUES (%s, %s) RETURNING TeamParticipation.id

[Robert Collins (lifeless)]

High as per Z-O-P. However I think edwin already landed a patch to dramatically reduce the overhead here; so closing fix released accordingly.