Forum OpenACS Development: Re: Res: Re: Res: Re: OpenACS performance issues

Collapse
16: Re: Res: Re: Res: Re: OpenACS performance issues (response to 15)
Posted by Dave Bauer on 03/06/08 01:00 PM
Those long permissions queries are suspicious. Normally checking one object takes 1ms or so.
Collapse
19: Re: Res: Re: Res: Re: OpenACS performance issues (response to 16)
Posted by Matthew Coupe on 03/06/08 01:29 PM
How can I find out more information about what query this is? 408ms is a loooong time for every page impression.


408 ms 0or1row dbqd.acs-tcl.tcl.acs-permissions-procs.permission::permission_p_not_cached.select_permission_p: 0or1row nsdb0

select 1 from dual
where exists
( select 1
from acs_object_party_privilege_map ppm
where ppm.object_id = '3551196' and ppm.party_id = '14554' and ppm.privilege = 'read' )