https://connect.hyland.com/t5/nuxeo-forum/acloptimization-flag/m-p/327850#M14851 <P>Hi <A href="https://app.quandora.com/object/4ea67552-e58a-4588-9eea-011263e1e1bf">Victor Sánchez</A></P> <P>Maybe this link could be helpful to get the info about acl optimization.</P> <P><A href="https://doc.nuxeo.com/display/ADMINDOC/Read+ACLs" target="test_blank">https://doc.nuxeo.com/display/ADMINDOC/Read+ACLs</A></P> <P>Best Regards,</P> Sat, 05 Mar 2016 11:48:15 GMT jmnrk_ 2016-03-05T11:48:15Z https://connect.hyland.com/t5/nuxeo-forum/acloptimization-flag/m-p/327849#M14850 <P>Hi all,</P> <P>this question is about aclOptimization flag into repository descriptor and trying to know how it works. My current scenario:</P> <UL> <LI>2 NX 6.0 instances clustered (over Ubuntu and PostgresSQL with tunning)</LI> <LI>12M documents into repository</LI> <LI>2 Elastic nodes clustered</LI> </UL> <P>So, if we have aclOptimization=true, NX initialization takes about 10-15min, so we have the function <EM>nx_update_read_acls</EM> running and running into DB. When it is started, Navigation is good (elastic works fine), searchs too, ... but for example, the operation for settting or removing permissions into UI or into a Worker (implemented by us) is during about <STRONG>4h</STRONG> and it ends always with ROLLBACK, <STRONG>so permission management is not possible</STRONG>; also, we can see a lot of call for nx_update_read_acls after session.save(), etcetera, ... We know the answer <A href="https://answers.nuxeo.com/general/q/36cb86bd181e47f2ad9009bde6833b63/How-to-modify-nx_update_read_acls-permanently">https://answers.nuxeo.com/general/q/36cb86bd181e47f2ad9009bde6833b63/How-to-modify-nx_update_read_acls-permanently</A>, but I don't look for a change in latest versions into Nuxeo github with Postgresql update.</P> <P>Then, the question is: if we set aclOptimization=false, and having NX starting about <STRONG>60s</STRONG> and navigation is normal too, managing permission is normally as well, etcetera... What is the real optimization of this aclOptimization? Only cache? If we have a aclOptimization=false, then navigation returns the ContentView documents OK (from elastic), NXQL with Default provider searchs OK and fast, … Also, If we want to activate again the flag to true and execute the <EM>nx_rebuild_read_acls</EM> function, it runs about <STRONG>10-20 hours</STRONG>...</P> <P>So, we are considering to disable aclOptimization to work fine, but Nuxeo distribution has aclOptimization=true by default. Is there any possible fix or changes to resolve it for a correct behavior?</P> <P>Thank you in advance.</P> <P>VS!</P> Fri, 04 Mar 2016 16:15:50 GMT https://connect.hyland.com/t5/nuxeo-forum/acloptimization-flag/m-p/327849#M14850 Victor_Sánchez 2016-03-04T16:15:50Z https://connect.hyland.com/t5/nuxeo-forum/acloptimization-flag/m-p/327850#M14851 <P>Hi <A href="https://app.quandora.com/object/4ea67552-e58a-4588-9eea-011263e1e1bf">Victor Sánchez</A></P> <P>Maybe this link could be helpful to get the info about acl optimization.</P> <P><A href="https://doc.nuxeo.com/display/ADMINDOC/Read+ACLs" target="test_blank">https://doc.nuxeo.com/display/ADMINDOC/Read+ACLs</A></P> <P>Best Regards,</P> Sat, 05 Mar 2016 11:48:15 GMT https://connect.hyland.com/t5/nuxeo-forum/acloptimization-flag/m-p/327850#M14851 jmnrk_ 2016-03-05T11:48:15Z https://connect.hyland.com/t5/nuxeo-forum/acloptimization-flag/m-p/327851#M14852 <P>Thank you [jmnrk](https</P> Sat, 05 Mar 2016 12:21:36 GMT https://connect.hyland.com/t5/nuxeo-forum/acloptimization-flag/m-p/327851#M14852 Victor_Sánchez 2016-03-05T12:21:36Z