-
Type:
Technical Task
-
Status: Closed
-
Priority:
Major
-
Resolution: Won't Fix
-
Affects Version/s: 6.2.0 CE M5
-
Fix Version/s: 6.2.0 CE M5
-
Component/s: Environments, Environments > Databases, ~[Archived] WCM
-
Labels:
-
Environment:Tomcat 7 + MySQL 5.5. Portal 6.2.x GIT ID: 06e81d2c98901c0ba546e9eb61b49e379d80b6a4.
Tomcat 7 + Oracle 11g. Portal 6.2.x GIT ID: 06e81d2c98901c0ba546e9eb61b49e379d80b6a4.
-
Epic/Theme:
-
Business Value:5
The following queries can be optimized by materializing the latest version in a separate entity and using an inner join instead of the combination of GROUP BY and MAX(version).
- JournalArticleFinder.findByG_U_C
- JournalArticleFinder.findByG_C_S
- JournalArticleFinder.findByC_G_F_C_A_V_T_D_C_T_S_T_D_R