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

Posted by Matthew Coupe on
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' )