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

Optimize the SQL query for UserFinderImpl

    Details

    • Branch Version/s:
      6.2.x, 6.1.x
    • Backported to Branch:
      Committed
    • Story Points:
      10

      Description

      1. Setup Liferay with SQL Server 2008 R2
      2. Create 2100 Organizations using data-manipulator-portlet
      3. Create a new Site
      4. Add all 2100 Organizations as a member of the Site (Site -> Click Actions -> select Manage Memberships -> Add Members -> Organization´╝ë
      5. Go to Control Panel -> Sites

        Attachments

        1. 43753_ee.6.2.x_fix.png
          43753_ee.6.2.x_fix.png
          11 kB
        2. 43753_master_error.png
          43753_master_error.png
          29 kB
        3. 43753_master_fix.png
          43753_master_fix.png
          14 kB
        4. 47353_ee.6.1.x_fix..png
          47353_ee.6.1.x_fix..png
          9 kB
        5. data-manipulator-portlet-6.1.20.11.war
          454 kB

          Issue Links

            Activity

              People

              Assignee:
              haoliang.wu Haoliang Wu (Inactive)
              Reporter:
              jonathan.mccann Jonathan McCann
              Participants of an Issue:
              Recent user:
              Minhchau Dang
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                7 years, 33 weeks, 6 days ago

                  Packages

                  Version Package
                  6.1.X EE
                  6.2.2 CE GA3
                  6.2.X EE
                  7.0.0 M1