Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-11448

Create function based indexes automatically to speed up case insensitive queries on the database

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Critical
    • None
    • 6.3
    • Storage
    • Unknown

    Description

      See the entire discussion on XWIKI-8691 about the need for automatically adding function based indexes (e.g. lower(DOC_FULLNAME)) for having a good performance with case insensitive queries that are currently not using any index at all.

      Options:

      • Use Hibernate's database mapping file when initializing a database (currently problematic, see XWIKI-8691's comments)
      • Use liquibase schema manipulation during a data migration

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              enygma Eduard Moraru
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: