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/11/09 02:31:47 UTC

[GitHub] [dolphinscheduler] darkz1984 commented on a diff in pull request #12826: Speed Up delete process from Web UI

darkz1984 commented on code in PR #12826:
URL: https://github.com/apache/dolphinscheduler/pull/12826#discussion_r1017343520


##########
dolphinscheduler-dao/src/main/resources/sql/dolphinscheduler_postgresql.sql:
##########
@@ -796,6 +797,7 @@ CREATE TABLE t_ds_task_instance (
 ) ;
 
 create index idx_task_instance_code_version on t_ds_task_instance (task_code, task_definition_version);
+create index idx_task_instance_process_instance_flag on t_ds_task_instance (process_instance_id, flag);

Review Comment:
   I just use postgresql
   
   and I found there are some foreign key in mysql
   I think it could be removed to improve



-- 
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