topic DB Perfomances: what does this call do ? "SELECT nx_update_read_acls()" in Nuxeo Forum

DB Perfomances: what does this call do ? "SELECT nx_update_read_acls()"

promanov_ — Fri, 20 Nov 2015 11:15:42 GMT

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?

Re: DB Perfomances: what does this call do ? "SELECT nx_update_read_acls()"

Greg_Drayon — Fri, 20 Nov 2015 13:58:37 GMT

About the title question, an answer can be found [here](https

Re: DB Perfomances: what does this call do ? "SELECT nx_update_read_acls()"

bruce_Grant — Fri, 20 Nov 2015 18:20:08 GMT

You could try overriding default-repository-config.xml and setting <aclOptimizations enabled="false" /> or better yet follow these instructions for mass import.