Description
Given:
A large PostgreSQL Task data set;
When:
Tasks are obtained for some given filter criteria.
Then:
The Task query is slow and inefficient because of the expensive sort operation caused by the DISTINCT statement.
Expected:
The Task Query is optimized by using the PostgreSQL DISTINCT ON statement when default ordering is used (by Task ID).
mgm-controller-panel
This is the controller panel for Smart Panels app
Attachments
Issue Links
- is related to
-
CAM-11277 Improve Task Query Performance
-
- Closed
-