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....@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 <br...@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<wsm...@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.
______________________
