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

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 6.3
    • Fix Version/s: None
    • Component/s: Storage
    • Labels:
    • Difficulty:
      Unknown
    • Similar issues:

      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

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

                Dates

                • Created:
                  Updated: