continuum-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From José Morales Martínez <jmora...@gmv.com>
Subject RE: Adding project groups takes longer and longer
Date Mon, 15 Jun 2009 23:42:12 GMT
When we create a projectgroup create a set of roles with their permissions. 

In my case I have created 56 groups and 1186 security_permissions with 1348  security_role_permission_map
and each time we create a projectGrup create 21 entries in security_permissions and 24 in

security_role_permission_map per projectgroup again. 

This problem occurs when creating the new permissions / roles, but the main problem occurs
when you first run the  method   'isAuthorized (projectGroup.getName ())' to list the 
results projectgroups in GroupSummaryAction.
________________________________________
De: Marica Tan [marica.tan@gmail.com]
Enviado el: martes, 16 de junio de 2009 1:40
Para: dev@continuum.apache.org
Asunto: Re: Adding project groups takes longer and longer

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
>>
>
>

______________________
Este mensaje, y en su caso, cualquier fichero anexo al mismo,
 puede contener informacion clasificada por su emisor como confidencial
 en el marco de su Sistema de Gestion de Seguridad de la 
Informacion siendo para uso exclusivo del destinatario, quedando 
prohibida su divulgacion copia o distribucion a terceros sin la 
autorizacion expresa del remitente. Si Vd. ha recibido este mensaje 
 erroneamente, se ruega lo notifique al remitente y proceda a su borrado. 
Gracias por su colaboracion.
______________________
This message including any attachments may contain confidential 
information, according to our Information Security Management System,
 and intended solely for a specific individual to whom they are addressed.
 Any unauthorised copy, disclosure or distribution of this message
 is strictly forbidden. If you have received this transmission in error,
 please notify the sender immediately and delete it.
______________________

Mime
View raw message