Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-10862

SQLServer: fix varchar conversion to enable index usage

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.6.0-HF09
    • Fix Version/s: 5.7.1
    • Component/s: Core VCS
    • Environment:
      MS SQLServer

      Description

      The MS SQLServer jdbc driver by default send string as unicode (sendStringParametersAsUnicode=true).

      The database can’t convert nvarchar() to varchar() and therefore don't use existing varchar index.

      All our uid ar varchar(36) which make direct access by id slow.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.