Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-47650

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

XMLWordPrintable

      NOTE: This bug report is for Confluence Cloud. Using Confluence Server? 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: