Forum OpenACS Development: Re: Compatibility Matrix

Collapse
26: Re: Compatibility Matrix (response to 25)
Posted by Dave Bauer on 08/02/12 05:47 PM
Here is where I am experiencing some issues

2.5 seconds:
update acs_objects
set security_inherit_p = 'f'
where object_id = '1290509'

1.6 seconds
select acs_permission__grant_permission(
'182879',
'27310',
'read'
);

So it appears that these are probably updating acs_object_party_privilege_map and related tables via triggers with this which will get really slow if you need to update more than 1 object. Its already pretty slow, several seconds to change permissions on 1 object.

Collapse
27: Re: Compatibility Matrix (response to 26)
Posted by Dave Bauer on 08/02/12 05:48 PM
I checked and I did update shared buffers to 128mb in my PG 9.1 config.
Collapse
28: Bugtrack updating many object permissions (response to 27)
Posted by Dave Bauer on 08/02/12 05:54 PM
Very interesting results.

If you try to change the access policy on a bugtracker instance it calls set_inherit and grant_permission on every bug.

This can be hundreds of objects. The first ones took 1-2 seconds per query as the page runs by the end the last objects take 1 ms.

It appears Postgresql is loading the tables/indexes into memory and as that happens to seems to help.

Maybe this is not a signifigant issue unless you try to issue hundreds of small queries in one submission.