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

                is related to

                Bug - A problem which impairs or prevents the functions of the product. XWIKI-8691 Sorting in the Livetable is case sensitive

                • Major - Major loss of function.
                • Closed

                  Activity

                    People

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

                      Dates

                      • Created:
                        Updated: