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

[GitBox <gi...@apache.org>]

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


##########
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:
   @darkz1984 you did a good job, 
   
   can you add these changes to mysql and H2 to keep the db file sync, I think it's not difficult for you ^_^



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