continuum-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marica Tan <marica....@gmail.com>
Subject Re: Adding project groups takes longer and longer
Date Mon, 15 Jun 2009 23:40:26 GMT
Here's what happens in GroupSummaryAction:

1. Get all project group --> query
2. Loop through each group
    - Check if user is authorized to view the project group --> query
    - If authorized, then get project group summary --> query


--
Marica

On Tue, Jun 16, 2009 at 7:25 AM, Brett Porter <brett@apache.org> wrote:

> That's insane.
>
> Is this all in the process of adding, or is a large portion coming from the
> group summary pages again?
>
> - Brett
>
>
> On 16/06/2009, at 6:56 AM, Wendy Smoak wrote:
>
>  On Mon, Jun 15, 2009 at 9:39 AM, Wendy Smoak<wsmoak@gmail.com> wrote:
>>
>>  To try to reproduce that, I added 400 groups to a fresh Continuum
>>> 1.3.3 instance.  I notice that it takes longer and longer to add each
>>> group.  Here's a graph:
>>>
>>> http://people.apache.org/~wsmoak/continuum/continuum-1.3.3-add-400-groups.png<http://people.apache.org/%7Ewsmoak/continuum/continuum-1.3.3-add-400-groups.png>
>>>
>>
>> Back to the "too many queries" idea, I found that
>> - adding group401 resulted in 61,144 queries
>> - adding group402 restulted in 61,278 queries
>>
>> --
>> Wendy
>>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message