[ https://issues.apache.org/jira/browse/SLING-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Mueller updated SLING-2940: ---------------------------------- Attachment: SLING-2940.patch Proposed patch > JCR queries for jcr:language: avoid using fn:lower-case > ------------------------------------------------------- > > Key: SLING-2940 > URL: https://issues.apache.org/jira/browse/SLING-2940 > Project: Sling > Issue Type: Improvement > Components: Extensions > Reporter: Thomas Mueller > Attachments: SLING-2940.patch > > > In SLING-2121, the query was changed to support both lowercase and uppercase > country codes in locales, for example "en_GB" and "en_gb". To do that, > fn:lower-case(jcr:language) = 'en_gb' is currently used. While it works, the > usage of fn:lower-case is problematic for the query engine in Jackrabbit and > specially Oak, because it is quite hard to use an index in this case. > To improve performance of this query with Oak, I suggest to use the longer > form with "or": jcr:language = 'en_gb' or jcr:language = 'en_GB'. In this > case, Jackrabbit / Oak can use an index. See also OAK-882 for index usage for > "or" conditions. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira