launchpad-dev team mailing list archive

[Robert Collins <robertc@xxxxxxxxxxxxxxxxx>]

On Wed, Feb 9, 2011 at 10:20 PM, Julian Edwards
<julian.edwards@xxxxxxxxxxxxx> wrote:
>> For the same root causes - constraining the intermediary tables that
>> are created, and the amount of data being processed, I'm growing more
>> and more concerned about the impact of wide queries - 'prejoins' on
>> our system; I'm starting to think we should have a default of set
>> based eager loading rather than wide-query eager loading : what do you
>> think?
>
> Can you give a concrete example?

bug 661988 - changing from a prejoin of Product and SourcePackageName
to serial queries drops 50% of of a multi second query.