How to optimize permissions on Nuxeo

pnux_ — Tue, 22 Oct 2019 15:49:24 GMT

Hi,

I use Nuxeo 10.10 (LTS 2019).

When i try to set permission to a large folder , the operation takes 23h to finish. And i have to do that for each group because when i set permission to one group, it's impossible to set permission for an other group as long as the last operation isn't finished.

The parameter aclOptimization was set to true.

I've tried to (steps):

set aclOptimization to false
set permission to all groups
execute SELECT nx_rebuild_read_acls();
set aclOptimization to true

With this solution it takes 4h but i'm not sure if is the right thing to do (i use this documentation : https://doc.nuxeo.com/nxdoc/read-acls/).

Is there another way to set permission to all groups in one time then execute the same procedures as if aclOptimization=true ? And/Or in less time if possible ?

Thank you.

Re: How to optimize permissions on Nuxeo

Patrick_Abgrall — Sat, 30 Nov 2019 17:53:51 GMT

See https://jira.nuxeo.com/browse/NXP-23788 if you use MongoDB (NXP implemented only for DBS => NoSQL) For SQL repositories, the way you perform this seems the way to go... Do you need ReadACLs turned ON? (Is performance affected if these are turned OFF?)

topic Re: How to optimize permissions on Nuxeo in Nuxeo Forum

How to optimize permissions on Nuxeo

Re: How to optimize permissions on Nuxeo