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

Many WC Articles titled with non-URL characters causes creation delays

    Details

      Description

      Description: If a database is full of Web Content articles without URL characters (common if a non-latin language is used). The default URL title "-" would be given to each of the articles. However, since we need unique URL titles, we need to rename the title which we do here:
      https://github.com/joshuacords/liferay-portal-ee/blob/3d591fa9614d54f6ce1417af11c72e1075061e15/modules/apps/web-experience/journal/journal-service/src/main/java/com/liferay/journal/service/impl/JournalArticleLocalServiceImpl.java#L3402-L3427

      Ultimately, this method of renaming causes problems starting around 7000 articles in which case the method had to try renaming the article 7000 times, each time looking up an article to check if the URL title has already been taken. This significantly impacts performance when publishing articles, taking several seconds or more to do so.

      Reproduction Steps:

      1. Create 7000 articles with the title "-", modify and use attached script
      2. Create an article in the same site as the 7000 articles with the title "သုတေသန"

      Expected Result: Article is immediately published
      Actual Result: Article takes ~20 seconds to publish

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              support-lep@liferay.com SE Support
              Reporter:
              joshua.cords Joshua Cords
              Participants of an Issue:
              Recent user:
              Joel Garman
              Engineering Assignee:
              Joshua Cords
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                1 year, 17 weeks, 2 days ago

                  Packages

                  Version Package
                  7.0.0 DXP FP86
                  7.0.10.12 DXP SP12
                  7.0.X