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
-
XWIKI-8691 Sorting in the Livetable is case sensitive
-
- Closed
-