[SYNCOPE-983] Search performance improvement with mandatory schemas only

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.10, 2.0.2, 2.1.0
• Component/s: core
• Assignee: Francesco Chicchiriccò
• Reporter: Francesco Chicchiriccò
• Created: 20/Dec/16 14:32
• Updated: 24/Jan/17 07:34
• Resolved: 22/Dec/16 08:33

Description

Currently, the internal search engine will always UNION the user_search_attr and user_search_null_attr.

When attribute conditions and order clauses are specified that only require mandatory schemas, this UNION can be skipped, with general performance improvement.