I also noticed the cache is reset everytime a new "resource" (e.g. project) is created. This means the cache is cleared then all the roles/permissions are queried again from the database and added to the cache. The reason behind this is probably for the redback custom tags used in the jsps, I think it uses the permissions in the cache to check whether the user should be able to access specific functionalities..
Thanks, Deng 2009/6/16 José Morales Martínez <[email protected]> > 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 [[email protected]] > Enviado el: martes, 16 de junio de 2009 1:40 > Para: [email protected] > 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 <[email protected]> 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<[email protected]> 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> > < > 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. > ______________________ >
