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

Improve performance of public message boards

    Details

      Description

      For message boards that are public, spiders continuously crawl all the threads. For every user that makes a post, a permission check is done to see if they are an admin or not. This check is only important if the viewing user is a moderator so we only run that check if the viewing user is a moderator. The permission check is a heavy one, especially if the user info is not in cache. Since the moderator check usually is false for most users, checking that first will eliminate a lot of unnecessary checks.

      Fixing this will benefit sites most if they have a large number of unique users that make posts and few number of moderators.

      For our own site, we saw a drop from 50k queries/hr to about 1.6k queries/hr for the queries needed to initialize the permission checker. This was also one of the queries that was running the most on our site.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  6.1.X EE
                  6.2.X EE
                  7.0.0 DXP FP13
                  7.0.0 DXP SP3
                  7.0.3 CE GA4
                  7.0.X EE
                  7.1.X
                  Master