njnu-seafish opened a new pull request, #18440: URL: https://github.com/apache/dolphinscheduler/pull/18440
<!--Thanks very much for contributing to Apache DolphinScheduler, we are happy that you want to help us improve DolphinScheduler! --> ## Was this PR generated or assisted by AI? NO ## Purpose of the pull request close #18439 ## Brief change log The queryWorkflowInstanceListPaging API is experiencing slow response times when querying workflow instances for projects with large amounts of historical data. This commit adds a composite index (project_code, start_time) to the t_ds_workflow_instance table to optimize the common query pattern that filters by project_code and sorts by start_time. Since project_code and start_time remain virtually unchanged after an instance is created, the index maintenance overhead is minimal. At the same time, it significantly boosts query performance for the most common scenarios. ## Verify this pull request <!--*(Please pick either of the following options)*--> This pull request is code cleanup without any test coverage. *(or)* This pull request is already covered by existing tests, such as *(please describe tests)*. (or) This change added tests and can be verified as follows: <!--*(example:)* - *Added dolphinscheduler-dao tests for end-to-end.* - *Added CronUtilsTest to verify the change.* - *Manually verified the change by testing locally.* --> (or) ## Pull Request Notice [Pull Request Notice](https://github.com/apache/dolphinscheduler/blob/dev/docs/docs/en/contribute/join/pull-request.md) If your pull request contains incompatible change, you should also add it to `docs/docs/en/guide/upgrade/incompatible.md` -- 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]
