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

Optionally use SQL arrays to store lists on PostgreSQL

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.6
    • Fix Version/s: 5.8.0-HF08, 5.9.3
    • Component/s: Core VCS
    • Tags:
    • Impact type:
      Configuration format change
    • Upgrade notes:
      Hide

      A given list field can be switched to database array storage using:

      <schema>
      <field type="array">some:field</field>
      </schema>

      To automatically enable database arrays for all list fields, use:

      <schema>
      <arrayColumns>true</arrayColumns>
      </schema>

      Show
      A given list field can be switched to database array storage using: <schema> <field type="array">some:field</field> </schema> To automatically enable database arrays for all list fields, use: <schema> <arrayColumns>true</arrayColumns> </schema>
    • Sprint:
      Sprint 1(5.9.3)

      Description

      A performance optimization that reduces SQL join overhead would be to optionally use SQL arrays if available (PostgreSQL, maybe Oracle) to store lists of primitive types defined in schemas. See Nuxeo Answers (http://answers.nuxeo.com/questions/3126/using-bit-strings-to-optimize-storage-and-retrieval-of-integer-list-types-that-have-a-length-or-maxlength-facet) for more information.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 2 days
                  2d
                  Remaining:
                  Remaining Estimate - 1 day
                  1d
                  Logged:
                  Time Spent - Not Specified Time Not Required
                  Not Specified