Details
-
Bug
-
Resolution: Timed out
-
Medium
-
3
-
Severity 2 - Major
-
Description
NOTE: This bug report is for Confluence Cloud. Using Confluence Server? See the corresponding bug report.
This query is slow, and in times of database latency can cause timeouts or other problems:
select label1_.LABELID AS x0_?_, customcont2_.TITLE AS x1_?_, labelling0_.LASTMODDATE AS x2_?_ FROM CONTENT_LABEL labelling0_, LABEL label1_, CONTENT customcont2_ WHERE customcont2_.CONTENTTYPE=? AND ((labelling0_.CONTENTID=customcont2_.CONTENTID )AND(customcont2_.PLUGINKEY=? )AND(customcont2_.CONTENT_STATUS=? )AND(label1_.LABELID=labelling0_.LABELID )AND(label1_.LABELID IN(? , ? , ? , ? , ? , ? , ? , ? , ?))AND(labelling0_.LASTMODDATE=(select max(labelling3_.LASTMODDATE) FROM CONTENT_LABEL labelling3_, LABEL label4_, CONTENT customcont5_ WHERE customcont5_.CONTENTTYPE=? AND ((labelling3_.CONTENTID=customcont5_.CONTENTID )AND(customcont5_.CONTENT_STATUS=? )AND(customcont5_.PLUGINKEY=? )AND(label4_.LABELID=labelling3_.LABELID )AND(labelling3_.LABELID=labelling0_.LABELID )) GROUP by label4_.LABELID , label4_.NAMESPACE , label4_.OWNER , label4_.NAME , label4_.LASTMODDATE , label4_.CREATIONDATE))) ORDER by label1_.LABELID DESC
Attachments
Issue Links
- is related to
-
CONFSERVER-47432 Improve performance of slow label query
- Closed
- relates to
-
CONFCLOUD-46669 Extremely slow CQ query on EAC
- Closed