Affects Version/s: 7.1.X, 7.2.X, 7.3.X, Master
When dealing with roles assigned to millions of users, the Users_Roles table lookup mya perform poorly. Similar to the solution from
LPS-95581, we should use a search index instead, to return the same results faster.
Steps to reproduce:
- Create millions of users and assign each of them a few new regular roles.
- Navigate to the roles page in the control panel.
Expected results: The page loads and displays how many users belong to each role
Actual results: The page takes a very long time to load, or the proxy server times out first.
Reproduced in master: 211d833d9105045a1d9ed96bee2ce1b4cde6a41a
Although this issue is difficult to reproduce, we have confirmation from a customer the solution works. It's also been demonstrated to work in
LPS-95581, since the solutions are almost identical (only different tables being used).