Comment 2 for bug 688785

Revision history for this message
Robert Collins (lifeless) wrote : Re: [Bug 688785] Re: Improvements to Launchpad web searches

This is an interesting proposal and part of our overall need to fix
our search story.

A few thoughts:
 - 'instant' isn't really all that precise a metric. Here are some stats:
   - we have 60K unique product/package names
   - bringing them all back in just psql is about 200ms - it will be
substantially more on an appserver due to networking and serialisation
overheasds
   - that overhead will be per request, + the calculation time per term.

So to make an acceptable overhead - say 500ms - we'd need the total
time to select an appropriate term in a 5 term search to be
(ballparking) under 10ms on a 60K corpus. Actual tests with an
appserver would be needed to be confident that this works well
enough.

This doesn't mean we can't do it, but it may mean that rather than a
simple approach we need some indexed.

-Rob