-
Bug
-
Resolution: Fixed
-
Medium
-
No-Version
-
Severity 3 - Minor
-
NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.
The Unanswered filter is takes 212 seconds in our contrived environment. The time in spent in this query. Currently, the imported 3,000 questions are marked unanswered
SELECT customcont0_.CONTENTID AS x0_?_ FROM CONTENT customcont0_ WHERE customcont0_.CONTENTTYPE=? AND ((customcont0_.PREVVER IS null )and(customcont0_.CONTENT_STATUS=? )and(customcont0_.PLUGINKEY=? )and(customcont0_.CONTENTID NOT in(select DISTINCT customcont1_.PARENTCCID FROM CONTENT customcont1_ WHERE customcont1_.CONTENTTYPE=? AND ((customcont1_.PREVVER IS null )and(customcont1_.CONTENT_STATUS=? )and(customcont1_.PLUGINKEY=? ))))) ORDER by customcont0_.CREATIONDATE DESC limit ?
- relates to
-
CONFCLOUD-47650 Unanswered questions query slow when there is a lot of unanswered questions
- Closed
- Testing discovered
-
CONFSERVER-47740 Recent questions for topic X query is slow
- Closed