[
https://issues.apache.org/jira/browse/OAK-8908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17063313#comment-17063313
]
Julian Reschke commented on OAK-8908:
-------------------------------------
Opened OAK-8963 for specifying the collation upon table creation.
This probably does not hurt, but does not seem to help wih the general perf
issues found for MySQL and SQL Server, see OAK-8926.
> 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)
