[ https://issues.apache.org/jira/browse/OAK-8908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Reschke updated OAK-8908: -------------------------------- Fix Version/s: (was: 1.26.0) 1.28.0 > RDBBlobStore on SQL Server: bad performance when default collation is of type > SQL* > ---------------------------------------------------------------------------------- > > Key: OAK-8908 > URL: https://issues.apache.org/jira/browse/OAK-8908 > Project: Jackrabbit Oak > Issue Type: Technical task > Components: rdbmk > Reporter: Julian Reschke > Assignee: Julian Reschke > Priority: Major > Fix For: 1.28.0 > > Attachments: OAK-8908-1.6.diff, OAK-8908.diff > > > RDBBlobStore uses a 64-char primary key (digest in hex). > Unfortunately, this causes performance issues on MS SQL Server, when the > collation for that column is of type "SQL*" (see links). These types of > collations are deprecated, but still the default for installations on the > "EN_US" locale. > The performance loss can be observed by changing the collation on an existing > install, and then enable performance logging on RDBBlobStore. -- This message was sent by Atlassian Jira (v8.3.4#803005)