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

Details

    Description

      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 ?

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-47650 Unanswered questions query slow when there is a lot of unanswered questions

          • Medium - Medium priority issues
          • Closed
          Testing discovered

          Bug - A problem which impairs or prevents the functions of the product. CONFCLOUD-47740 Recent questions for topic X query is slow

          • Medium - Medium priority issues
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: