Comment 1 for bug 636151

On Sun, Sep 12, 2010 at 3:45 PM, Jeroen T. Vermeulen
<email address hidden> wrote:
> Public bug reported:
>
> I'm having a look at the performance of the front page.  It just took
> 5,331ms to render, 4,556 of which was "SQL time."  (It probably got
> faster once memcached was primed for my personal fragments).

Do you mean 'launchpad.net', or one of the site specific root pages?

> Then, a lot of database queries for the featured-project listing could
> be avoided by prejoining Product, Product.icon (LibraryFileAlias),
> Product.icon.content (LibraryFileContent), and the licensing information

LibraryFileContent should never be needed by the appserver in GET requests.

If you saw requests for Product.icon.content, you probably were
looking at lpnet; have a look at edge - it shouldn't be doing that
lookup anymore.

-Rob