You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2022/02/24 03:54:09 UTC

[GitHub] [dolphinscheduler] caishunfeng commented on a change in pull request #8290: [Improvement][SQL] Performance optimization for a large number(10k) of tasks

caishunfeng commented on a change in pull request #8290:
URL: https://github.com/apache/dolphinscheduler/pull/8290#discussion_r813525237



##########
File path: dolphinscheduler-dao/src/main/resources/sql/dolphinscheduler_postgresql.sql
##########
@@ -489,6 +489,8 @@ CREATE TABLE t_ds_process_task_relation_log (
 
 create index process_task_relation_log_idx_project_code_process_definition_code on t_ds_process_task_relation_log (project_code,process_definition_code);
 
+create index idx_process_code_version on t_ds_process_task_relation_log (process_definition_code, process_definition_version);

Review comment:
       miss this ddl in mysql, please take a check.




-- 
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: commits-unsubscribe@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org