Projects:EntityAccessChecker Perfomance Improvements/Specs
The main functional goal of this project is to keep the entity access checker process of the backend working as usual, but with a better performance in terms of scalability thanks to the changes that will be introduced.
This project will not add new features, the changes involved within this project should be transparent: they must continue working as usual.
General Performance Improvements
There are some general improvements that will be applied for the Entity Access Checker process itself. They all help to reduce the time spent in Entity Access Checker process in complex enviroments with lots of logins into the ERP. It have been checked that there exists a lots of queries that generates an overhead when this process is executed lots of times. In order to solve this problem, some info should be cached in order to reduce the time spent this process since the second time.
These are the queries that should be remove. See the results in this spreadsheet.