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

Recent questions for topic X query is slow

    XMLWordPrintable

Details

    Description

      NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

      SELECT customcont0_.CONTENTID AS x0_?_ FROM CONTENT customcont0_WHERE customcont0_.CONTENTTYPE=? AND ((customcont0_.CONTENTID IN(select customcont1_.CONTENTID FROM CONTENT customcont1_, CONTENT_LABEL labelling2_ WHERE customcont1_.CONTENTTYPE=? AND ((customcont1_.PREVVER IS null )and(customcont1_.CONTENT_STATUS=? )and(customcont1_.PLUGINKEY=? )and(labelling2_.CONTENTID=customcont1_.CONTENTID )and(labelling2_.LABELID IN(?)))GROUP by customcont1_.CONTENTID , customcont1_.CREATIONDATEHAVING (count(labelling2_.ID)=? )))) ORDER by customcont0_.CREATIONDATE DESC limit ?

      Attachments

        1. confluence-questions-1.0.449.obr
          2.40 MB
          Julien Michel Hoarau
        2. confluence-questions-1.0.450.obr
          2.40 MB
          Julien Michel Hoarau

        Issue Links

          Discovered while testing

          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
          relates to

          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
          Testing discovered

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-47962 Variable performance for /rest/questions/1.0/statistics

          • Medium - Medium priority issues
          • Closed

          Activity

            People

              jhoarau Julien Michel Hoarau (Inactive)
              stardif Sam Tardif
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: