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

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

    XMLWordPrintable

    Details

      Description

      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 ?
      
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: