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

db2: queries that use 'lower' do not use index because of case sensitivity

    XMLWordPrintable

Details

    • 5
    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

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

      Most of the queries against CONTENT table use 'lower' db function for a title field. The goes for (space) key field in SPACES table.
      We do it to make a case insensitive comparison, however it means that db2 does not use the existing indexes for those fields and performs a full table scan.
      This results in a poor performance.

      This can be applicable to other database too, but it is not verified. Also other databases may have global 'case sensitivity' flag.

      Attachments

        1. lower-func-performance.patch
          34 kB
        2. lower-func-performance.patch
          28 kB
        3. lower-func-performance.patch
          18 kB
        4. lower-func-performance.patch
          19 kB
        5. lower-func-performance.patch
          3 kB

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-12319 Adding users to a large group is slow with default (Hibernate) user management

          • High - High priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-9152 InnoDB vs MyISAM discrepancy with MySQL

          • Medium - Medium priority issues
          • Closed
          relates to

          Suggestion - CONFCLOUD-10030 db2: queries that use 'lower' do not use index because of case sensitivity

          • Closed
          was cloned as

          Suggestion - CONFSERVER-11577 Store pre-lowercased content titles for more efficient lookup

          • Closed

          Activity

            People

              matt@atlassian.com Matt Ryall
              akazatchkov Anatoli
              Votes:
              11 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: