Describe the bug
Due to the use of the SQL Having clause with vary large numbers of Graphs, the Cacti permission system does not work in cases other than the 'simple' permissions workaround. In order to resolve this issue, Cacti must move away from the use of SQL Having clauses to improve page performance.
To Reproduce
Steps to reproduce the behavior:
-
Have several hundred thousand graphs
-
Have several tens of thousands of devices
-
Have several thousand users
-
Attempt to set finite permissions either based upon a user or group
-
Watch Cacti burn 💯
Expected behavior
Cacti should behave better on large installs
Describe the bug
Due to the use of the SQL Having clause with vary large numbers of Graphs, the Cacti permission system does not work in cases other than the 'simple' permissions workaround. In order to resolve this issue, Cacti must move away from the use of SQL Having clauses to improve page performance.
To Reproduce
Steps to reproduce the behavior:
Have several hundred thousand graphs
Have several tens of thousands of devices
Have several thousand users
Attempt to set finite permissions either based upon a user or group
Watch Cacti burn 💯
Expected behavior
Cacti should behave better on large installs