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

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X
• Fix Version/s: 7.0.0 DXP FP86, 7.0.10.12 DXP SP12, 7.0.X
• Component/s: ~[Archived] WCM
• Labels:
  • ee-ts
  • liferay-dxp-70-sp12
  • liferay-fixpack-de-86-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/liferay/liferay-portal-ee/pull/16318

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