Comment 4 for bug 5415
Revision history for this message
| Christian Reis (kiko) wrote Re: [Bug 5415] Launchpad times out while searching for a person | #4 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
bbfa235
(Get the code!)
On Tue, Dec 06, 2005 at 08:48:05PM -0000, Guilherme Salgado wrote:
> This is the query that gets the preferred email of one of the persons/teams
> whose name/email matched the text you entered. In case of Matthew (not sure if
> yours is the same), this query (and some others) had to be executed almost
> 1400 times, so that's probably what causes the problem.
I suspect we could work around this by using an SQL view (because we
could be doing a single query), though the end-result would still be
ghastly because, simply put, there are too many results matching that.
We need a UI answer to that part of the problem -- Matthew?
We could list a small number of results and then say (511 other
matches...). We could also try and display a "best selection" -- one
criterium could be "people that belong to the team that owns the product
or distro". However, I have no suggestion on how to handle the UI for
selecting somebody from the "other matches" group. :-(