You are viewing a plain text version of this content. The canonical link for it is here.
Posted to oak-issues@jackrabbit.apache.org by "Julian Reschke (Jira)" <ji...@apache.org> on 2020/02/14 14:47:00 UTC
[jira] [Commented] (OAK-8908) RDB*Store on SQL Server: bad
performance when default collation is of type SQL*
[ https://issues.apache.org/jira/browse/OAK-8908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17037020#comment-17037020 ]
Julian Reschke commented on OAK-8908:
-------------------------------------
Example for changing the collation:
{{use *_DBNAME_*}}
{{alter table DATASTORE_DATA drop constraint *_DATA_PK_*}}
{{alter table DATASTORE_DATA ALTER COLUMN ID VARCHAR(64) COLLATE Latin1_General_CI_AS not null}}
{{alter table DATASTORE_DATA add constraint *_DATA_PK_* primary key clustered (ID)}}
{{alter table DATASTORE_META drop constraint *_META_PK_*}}
{{alter table DATASTORE_META ALTER COLUMN ID VARCHAR(64) COLLATE Latin1_General_CI_AS not null}}
{{alter table DATASTORE_META add constraint *_META_PK_* primary key clustered (ID)}}
> 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
>
>
> 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)