[
http://jira.nuxeo.org/browse/NXP-4398?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benoit Delbosc updated NXP-4398:
--------------------------------
Tags: performance read_acl TATeamSupportRequest (was: performance read_acl)
> Optmize read acl update by not rebuilding the full read_acls table
> ------------------------------------------------------------------
>
> Key: NXP-4398
> URL: http://jira.nuxeo.org/browse/NXP-4398
> Project: Nuxeo Enterprise Platform
> Issue Type: Improvement
> Affects Versions: 5.3 GA
> Reporter: Benoit Delbosc
> Assignee: Benoit Delbosc
> Priority: Major
> Fix For: 5.3.1
>
> Original Estimate: 4 hours
> Remaining Estimate: 4 hours
>
> The nx_update_read_acls rebuild the read_acls table that contains all
> possible read acls, then it update the read acls for new documents:
> RAISE INFO 'nx_rebuild_read_acls truncate hierarchy_read_acl';
> TRUNCATE TABLE hierarchy_read_acl;
> RAISE INFO 'nx_rebuild_read_acls update acl map';
> INSERT INTO hierarchy_read_acl
> SELECT id, md5(nx_get_read_acl(id))
> FROM (SELECT id FROM hierarchy WHERE isproperty='f') AS uids;
> This is fine if you have few dozen of acls, with thousands of acls it takes
> time.
> A simple optimization is to rebuild this table only if we have new entry with
> an acls.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
