[
https://issues.apache.org/jira/browse/OAK-8908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17040091#comment-17040091
]
Julian Reschke edited comment on OAK-8908 at 2/19/20 2:25 PM:
--------------------------------------------------------------
One way to fix this is to set a property in the SQLServer JDBC URL; see
"sendStringParametersAsUnicode" in
<https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15>.
The downside is that this will break RDBDocumentStore's use of the DATA column;
will try to address that with a patch.
Update: see [^OAK-8908.diff]
was (Author: reschke):
One way to fix this is to set a property in the SQLServer JDBC URL; see
"sendStringParametersAsUnicode" in
<https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15>.
The downside is that this will break RDBDocumentStore's use of the DATA column;
will try to address that with a patch.
> RDB*Store 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.26.0
>
> Attachments: 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)
