Branch:+index timeouts - 3 queries triggered per linked bug

[Steve Magoun]

 84 SELECT BugTask.assignee, BugTask.bug, BugTask.bugwatch, BugTask.date_assigned, BugTask.date_close ... ON BugTask.bugwatch = "_prejoin5".id WHERE BugTask.bug = $INT AND ($INT=$INT) ORDER BY BugTask.id:
   GET: 84 Robots: 0 Local: 62
     21 https://code.launchpad.net/%7Eopenerp/openobject-client-web/trunk/+index (Branch:+index)
       OOPS-1880B1505, OOPS-1880B190, OOPS-1880B355, OOPS-1880C711, OOPS-1880C712
     10 https://code.launchpad.net/%7Eopenerp/openobject-addons/5.0/+index (Branch:+index)
       OOPS-1880A2197, OOPS-1880C2256, OOPS-1880D2210, OOPS-1880E2448, OOPS-1880F2489
      8 https://code.launchpad.net/%7Esoftware-store-developers/software-center/trunk/+index (Branch:+index)
       OOPS-1880B439, OOPS-1880C2355, OOPS-1880E2284, OOPS-1880G2141, OOPS-1880G441
   [19 other URLs]

Picking one:

Branch: launchpad-rev-12432
Revno: 12432
SQL time: 9963 ms
Non-sql time: 4292 ms
Total time: 14255 ms
Statement Count: 328

8.9 seconds in repeated lookups of bugs:
265 8999 33 8966

There are 375 linked bugs on the software centre branch.

[Robert Collins (lifeless)]

OOPS-1881C305 shows 3 repeats, and in the recent commits 3 linked bugs and one bug linkified from text in the commit message.

https://code.launchpad.net/~bzr-pqm/bzr/bzr.dev/+index

so at first blush I think its the showing of merge proposals.

[Robert Collins (lifeless)]

https://code.launchpad.net/~openerp/openobject-client-web/trunk/++branch-revisions renders totally fine, so I think its not the merge proposal thing per se.

[Robert Collins (lifeless)]

Linked bugs add 3 queries per bug at the moment.

[Robert Collins (lifeless)]

Ok, I have a solid fix for the core of this bug, though there is more to go to to comprehensively solve it. Most bugs are pillar bugs though - so I'm going to get my current work merged, close this bug if the representative branches are happier, and come back to the remainder once more fires are out.

[Launchpad QA Bot (lpqabot)]

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

[Robert Collins (lifeless)]

https://code.qastaging.launchpad.net/~software-store-developers/software-center/trunk/+index renders in 75 queries - 12 seconds *cold* on qastaging. 1.6 seconds hot.