-
Bug
-
Resolution: Fixed
-
Medium
-
Severity 3 - Minor
-
NOTE: This bug report is for Confluence Cloud. Using Confluence Server? See the corresponding bug report.
SELECT customcont0_.CONTENTID AS x0_?_ FROM CONTENT customcont0_WHERE customcont0_.CONTENTTYPE=? AND ((customcont0_.CONTENTID IN(select customcont1_.CONTENTID FROM CONTENT customcont1_, CONTENT_LABEL labelling2_ WHERE customcont1_.CONTENTTYPE=? AND ((customcont1_.PREVVER IS null )and(customcont1_.CONTENT_STATUS=? )and(customcont1_.PLUGINKEY=? )and(labelling2_.CONTENTID=customcont1_.CONTENTID )and(labelling2_.LABELID IN(?)))GROUP by customcont1_.CONTENTID , customcont1_.CREATIONDATEHAVING (count(labelling2_.ID)=? )))) ORDER by customcont0_.CREATIONDATE DESC limit ?
- Discovered while testing
-
CONFCLOUD-47650 Unanswered questions query slow when there is a lot of unanswered questions
-
- Closed
-
- is related to
-
CONFSERVER-47740 Recent questions for topic X query is slow
-
- Closed
-
- Testing discovered
-
CONFCLOUD-47962 Variable performance for /rest/questions/1.0/statistics
-
- Closed
-
[CONFCLOUD-47740] Recent questions for topic X query is slow
Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2371718 ] | New: JAC Bug Workflow v3 [ 3417733 ] |
Status | Original: Resolved [ 5 ] | New: Closed [ 6 ] |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 [ 2255102 ] | New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2371718 ] |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2206981 ] | New: Confluence Workflow - Public Facing - Restricted v5 [ 2255102 ] |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2151920 ] | New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2206981 ] |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 [ 1907224 ] | New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2151920 ] |
Workflow | Original: Confluence Workflow - Public Facing - Restricted v3 [ 1811010 ] | New: Confluence Workflow - Public Facing - Restricted v5 [ 1907224 ] |
Description |
Original:
{noformat} SELECT customcont0_.CONTENTID AS x0_?_ FROM CONTENT customcont0_WHERE customcont0_.CONTENTTYPE=? AND ((customcont0_.CONTENTID IN(select customcont1_.CONTENTID FROM CONTENT customcont1_, CONTENT_LABEL labelling2_ WHERE customcont1_.CONTENTTYPE=? AND ((customcont1_.PREVVER IS null )and(customcont1_.CONTENT_STATUS=? )and(customcont1_.PLUGINKEY=? )and(labelling2_.CONTENTID=customcont1_.CONTENTID )and(labelling2_.LABELID IN(?)))GROUP by customcont1_.CONTENTID , customcont1_.CREATIONDATEHAVING (count(labelling2_.ID)=? )))) ORDER by customcont0_.CREATIONDATE DESC limit ? {noformat} |
New:
{panel:bgColor=#e7f4fa} *NOTE:* This bug report is for *Confluence Cloud*. Using *Confluence Server*? [See the corresponding bug report|http://jira.atlassian.com/browse/CONFSERVER-47740]. {panel} {noformat} SELECT customcont0_.CONTENTID AS x0_?_ FROM CONTENT customcont0_WHERE customcont0_.CONTENTTYPE=? AND ((customcont0_.CONTENTID IN(select customcont1_.CONTENTID FROM CONTENT customcont1_, CONTENT_LABEL labelling2_ WHERE customcont1_.CONTENTTYPE=? AND ((customcont1_.PREVVER IS null )and(customcont1_.CONTENT_STATUS=? )and(customcont1_.PLUGINKEY=? )and(labelling2_.CONTENTID=customcont1_.CONTENTID )and(labelling2_.LABELID IN(?)))GROUP by customcont1_.CONTENTID , customcont1_.CREATIONDATEHAVING (count(labelling2_.ID)=? )))) ORDER by customcont0_.CREATIONDATE DESC limit ? {noformat} |
Link |
New:
This issue is related to |
Project Import | New: Sat Apr 01 14:06:06 UTC 2017 [ 1491055566265 ] |