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

Store pre-lowercased content titles for more efficient lookup

XMLWordPrintable

    • 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.

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

      Most databases do not index varchar() fields in a way that is friendly to case-insensitive lookups. There are per-database solutions to this (function indexes in Oracle, generated columns in DB2, etc), but no easy general solution. Since one of the most frequent lookups we do is matched against the lower(title) column of the CONTENT table, we should store a pre-lowercased value of content titles in the database and look up against that instead.

      (see CONF-10030)

        1. lower-func-performance.patch
          32 kB

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

            Sen Geronimo made changes -
            Workflow Original: JAC Suggestion Workflow 4 [ 3576591 ] New: JAC Suggestion Workflow 3 [ 4326992 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow 2 [ 3169335 ] New: JAC Suggestion Workflow 4 [ 3576591 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3031013 ] New: JAC Suggestion Workflow 2 [ 3169335 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing v4 [ 2534042 ] New: JAC Suggestion Workflow [ 3031013 ]
            Rachel Lin (Inactive) made changes -
            Workflow Original: Confluence Workflow - Public Facing v3 [ 2294127 ] New: Confluence Workflow - Public Facing v4 [ 2534042 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing v3 - TEMP [ 2189024 ] New: Confluence Workflow - Public Facing v3 [ 2294127 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing v3 [ 1918797 ] New: Confluence Workflow - Public Facing v3 - TEMP [ 2189024 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing v2 [ 1757932 ] New: Confluence Workflow - Public Facing v3 [ 1918797 ]
            jonah (Inactive) made changes -
            Description Original: Most databases do not index varchar() fields in a way that is friendly to case-insensitive lookups. There are per-database solutions to this (function indexes in Oracle, generated columns in DB2, etc), but no easy general solution. Since one of the most frequent lookups we do is matched against the lower(title) column of the CONTENT table, we should store a pre-lowercased value of content titles in the database and look up against that instead.

            (see CONF-10030)             		New: {panel:bgColor=#e7f4fa}
              *NOTE:* This suggestion is for *Confluence Server*. Using *Confluence Cloud*? [See the corresponding suggestion|http://jira.atlassian.com/browse/CONFCLOUD-11577].
              {panel}

            Most databases do not index varchar() fields in a way that is friendly to case-insensitive lookups. There are per-database solutions to this (function indexes in Oracle, generated columns in DB2, etc), but no easy general solution. Since one of the most frequent lookups we do is matched against the lower(title) column of the CONTENT table, we should store a pre-lowercased value of content titles in the database and look up against that instead.

            (see CONF-10030)
            jonah (Inactive) made changes -
            Link New: This issue relates to CONFCLOUD-11577 [ CONFCLOUD-11577 ]

              Unassigned Unassigned
              cmiller@atlassian.com Charles Miller (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: