Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-47650

Unanswered questions query slow when there is a lot of unanswered questions

XMLWordPrintable

      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 ?
      
      

              jhoarau Julien Michel Hoarau (Inactive)
              jhoarau Julien Michel Hoarau (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: