Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-123874

Poor performance in Roles page with millions of assigned roles

    Details

      Description

      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:

      1. Create millions of users and assign each of them a few new regular roles.
      2. 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).

        Attachments

          Activity

            People

            Assignee:
            patricia.perez Patricia Perez
            Reporter:
            christopher.kian Christopher Kian
            Participants of an Issue:
            Recent user:
            Yunlin "Steven" Sun
            Engineering Assignee:
            Christopher Kian
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              11 weeks, 4 days ago

                Packages

                Version Package
                7.2.10 DXP FP10
                7.2.X
                7.3.X
                Master