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/12/03 14:08:18 UTC

[GitHub] [dolphinscheduler] EricGao888 commented on pull request #12826: Speed Up delete process from Web UI

EricGao888 commented on PR #12826:
URL: https://github.com/apache/dolphinscheduler/pull/12826#issuecomment-1336167856

   @darkz1984 I don't doubt that creating an index on the combination of `(process_instance_id, flag)` for table `t_ds_task_instance` could significantly improve the querying efficiency of the sql sentence you post in this issue, which you used to manually deleted the stuff from db. But I don't think this index could improve any of the queries in `TaskInstanceMapper.xml`. It is not meaningful for the upstream code.
   
   https://github.com/apache/dolphinscheduler/blob/dev/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/TaskInstanceMapper.xml


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