timeouts for branch listing for user with a *lot* of branches

[James Westby]

https://code.edge.launchpad.net/~ubuntu-branches

is starting to timeout for me. This started occurring about 25,000 branches,
so it's unlikely to many users, but this overview is very useful for me.

Thanks,

James

[Tim Penhey (thumper)]

Can I get you to check again, or to paste oops ids if you get them.

This works for me:

<!-- at least 345 queries issued in 3.61 seconds -->
<!-- Launchpad 2.2.6 (r8791) -->

[Tim Penhey (thumper)]

Actually I think this has to do with the inefficient way we generate lp: links for official package branches.

[James Westby (james-w)]

e.g. OOPS-1286ED84

Thanks,

James

[Tim Penhey (thumper)]

I'm looking at this now.

[Tim Penhey (thumper)]

This has been partially fixed, but not to my complete satisfaction yet. So deferring to 2.2.8 to finish the fix.

[Eledran (eledran-deactivatedaccount)]

It does not only affect projects, it also strikes at individual users pages, such as lp:~mwhudson at edge and staging enviroment.

IDs:

Edge - OOPS-1307EA21

Staging - OOPS-1307S390

[Tim Penhey (thumper)]

Actually those ones are bug 396593 and should be ok when edge updates.

[Tim Penhey (thumper)]

Fixing this got trumped by the 3.0 UI work. Should be able to look at it for post 3.0.

The query count on these pages is still very high, but it doesn't seem to be timing out every time right now.