-
Type: Improvement
-
Status: Resolved
-
Priority: Minor
-
Resolution: Duplicate
-
Affects Version/s: 5.2 GA
-
Fix Version/s: None
-
Component/s: Core VCS, Query & PageProvider
-
Tags:
Nuxeo suffers of huge performance problem while the repository is growing up :
the navigation becomes more and more difficult and the problem origin is how we are using NX_ALLOWED_ACCESS stored procedure : this and function is called on each line of hierarchy table and the query planner of the database never build subqueries, even if we set a huge cost to this stored procedure.
So we have to manually build a sub- select for the user query and on this result run NX_ALLOWED_ACCESS.