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

Store pre-lowercased content titles for more efficient lookup

    Details

    • Last commented by user?:
      true

      Description

      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)

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                3 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Last commented:
                  3 years, 38 weeks, 1 day ago