-
Type: Improvement
-
Status: Open
-
Priority: Major
-
Resolution: Unresolved
-
Affects Version/s: 5.8.0-HF31
-
Fix Version/s: QualifiedToSchedule
-
Component/s: Core VCS
-
Tags:
When NXQL queries like this are very slow
SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND ecm:currentLifeCycleState NOT IN ('ended', 'cancelled') AND ecm:isProxy = 0 AND (nt:targetDocumentId = ? OR nt:targetDocumentsIds IN (?)) AND (nt:actors IN (?) OR nt:delegatedActors IN (?))";
Adding a GIN index on mixintype fix the problem
CREATE INDEX hierarchy_mixintypes_idx ON hierarchy USING GIN(mixintypes);
- depends on
-
NXP-16113 Do not use dynamical facets for tasks
- Resolved