DB Perfomances: what does this call do ? "SELECT nx_update_read_acls()"
We observe a substantial time consumption logged this function in PostgreSQL.
Is this something that can be deactivated for a mass data import and executed at the end once?
0 votes
1 answers
2168 views
You could try overriding default-repository-config.xml and setting <aclOptimizations enabled="false" /> or better yet follow these instructions for mass import.
 |
bruce Grant
Member (7.6K) 2 7 6 |
11/20/2015 ( History) |
`aclr_modified` table:> This table is filled while a set of ACL modifications are in progress, and when the Nuxeo session is saved the stored procedure NX_UPDATE_READ_ACLS is called to recompute what's needed according to hierarchy_modified_acl, which is then emptied.
No idea how to disable it temporarily to run it once at the end, though.