fanzhenyu95 commented on PR #17756:
URL:
https://github.com/apache/dolphinscheduler/pull/17756#issuecomment-3654095256
@SbloodyS @ruanwenjun Thank you for your feedback! The pagination queries
for **project list**, **workflow instance list**, and **task instance list**
are significantly slow in production environments with large datasets, leading
to long page loading times and poor user experience.
Frequently used interfaces with slow query performance include:
1. **Project list API**: `GET /projects`
2. **Workflow instance list API**: `GET
/projects/{projectCode}/workflow-instances`
3. **Task instance list API**: `GET /projects/{projectCode}/task-instances`
While adding indexes alone may not solve all performance issues, in our
specific scenario with tables containing millions of records, list queries were
taking over 10 seconds to execute and sometimes even failed to return results.
After implementing the proposed indexes, all list queries now perform normally
with acceptable response times.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
