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*

    XMLWordPrintableJSON

    Details

    • Type: Technical task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 1.40.0
    • Component/s: rdbmk
    • Labels:
      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

        1. OAK-8908.diff
          5 kB
          Julian Reschke
        2. OAK-8908-1.6.diff
          5 kB
          Julian Reschke

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                reschke Julian Reschke
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated: