Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-1266 DocumentStore implementation for relational databases
  3. OAK-8908

RDBBlobStore on SQL Server: bad performance when default collation is of type SQL*

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Technical task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • rdbmk
    • None

    Description

      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.

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            reschke Julian Reschke

            Dates

              Created:
              Updated:

              Slack

                Issue deployment