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

Utilize Users_Orgs mapping table to do in memory reault filtering

    Details

      Description

      For this particular usage, base on the fact that user normally belongs to very limited number of organizations. The user to org mapping result is cachable without causing a notable memory occupation.
      I optimized the user to org sql filtering query in OrganizationLocalServiceImpl to be full mapping query without filter, then process the result in memory. The full mapping query is cached at persistence layer, most likely after warm up won't fire out a db query, and the organization data set per user is very small, process in memory is very efficient.

      This solution will add a slight overhead on portal side, but reduce quite a lot database activity. In most cases, the net output should be an improvement.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              david.truong David Truong
              Reporter:
              shuyang.zhou Shuyang Zhou
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:

                  Packages

                  Version Package
                  6.2.0 CE M3