[NXP-10182] Optionally use SQL arrays to store lists on PostgreSQL - Nuxeo Issue Tracker

XML

Word

Printable

Tags:
- nxRepoTeam
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)

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.

is required by

NXP-13882 Tag cloud is broken

NXP-13928 Fix schema-based property column size specification

NXP-15096 Fix unit test about invalidations when using array columns

Estimated:

Remaining:

Logged:

Not Specified