-
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:
-
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.