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

Recent questions for topic X query is slow

XMLWordPrintable

      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 ?

        1. confluence-questions-1.0.449.obr
          2.40 MB
        2. confluence-questions-1.0.450.obr
          2.40 MB

            [CONFSERVER-47740] Recent questions for topic X query is slow

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2900692 ] New: CONFSERVER Bug Workflow v4 [ 2995435 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2796091 ] New: JAC Bug Workflow v3 [ 2900692 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2718113 ] New: JAC Bug Workflow v2 [ 2796091 ]
            Owen made changes -
            Symptom Severity Original: Minor [ 14432 ] New: Severity 3 - Minor [ 15832 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2379691 ] New: JAC Bug Workflow [ 2718113 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2270368 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2379691 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2223556 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2270368 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2178903 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2223556 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1944871 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2178903 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1733063 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1944871 ]

              jhoarau Julien Michel Hoarau (Inactive)
              stardif Sam Tardif
              Affected customers:
              0 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: