Product:+code-index timeouts
Bug #736008 reported by
Robert Collins
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
Robert Collins |
Bug Description
1 SELECT DISTINCT BugBranch.branch FROM Bug, BugBranch WHERE BugBranch.branch IN ($INT ... $INT) AN ... ation WHERE TeamParticipati
GET: 1 Robots: 0 Local: 1
1 https:/
OOPS-1900C1273
Related branches
lp:~lifeless/launchpad/bug-736008
- Steve Kowalik (community): Approve
-
Diff: 421 lines (+169/-55)3 files modifiedlib/lp/code/model/branchcollection.py (+166/-52)
lib/lp/code/model/tests/test_branchcollection.py (+2/-2)
versions.cfg (+1/-1)
Changed in launchpad: | |
status: | Fix Committed → In Progress |
Changed in launchpad: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
SELECT COUNT(*) id=branchmergep roposal. source_ branch and source.product=7432 join branch as target on target. id=branchmergep roposal. target_ branch
(SELECT Branch.id
FROM Branch,
TeamParticipa tion
WHERE Branch.OWNER = TeamParticipati on.team
AND TeamParticipati on.person = 790463
AND Branch.private = TRUE)
UNION
(SELECT Branch.id
FROM Branch,
BranchSubscri ption,
TeamParticipa tion
WHERE BranchSubscript ion.branch = Branch.id
AND BranchSubscript ion.person = TeamParticipati on.team
AND TeamParticipati on.person = 790463
AND Branch.private = TRUE)) private= false or target.id IN(
(SELECT Branch.id
FROM Branch,
TeamPartici pation
WHERE Branch.OWNER = TeamParticipati on.team
AND TeamParticipati on.person = 790463
AND Branch.private = TRUE)
UNION
(SELECT Branch.id
FROM Branch,
BranchSubsc ription,
TeamPartici pation
WHERE BranchSubscript ion.branch = Branch.id
AND BranchSubscript ion.person = TeamParticipati on.team
AND TeamParticipati on.person = 790463
AND Branch.private = TRUE)) osal.queue_ status IN (3,
2)
FROM BranchMergeProposal join branch as source on source.
WHERE source.private = false or source.id in(
AND target.
AND BranchMergeProp
looks like a significant improvement on the branch merge proposal queries - 39 and 40 in OOPS-1906G1635 - which btw are identical, so another source of potential improvement.