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

   @EricGao888 @ruanwenjun 
   I detect this problem in my dolphinscheduler, and delete the process 
instance too slow, may be more than 10 minutes.
   And i follow the database process of dolphinscheduler, see this slow 
database query.
   Then I add this index,  the action end in  some seconds.
   
   I have some process in dolphinscheduler run each 5 minutes, so some process 
definition has much process instance and mo task instance.  
   About 20,000+ task instance of the process definition. So the delete of 
process definition too slow.
   if the process in dolphinscheduler just run every day, delete of the process 
definition is fast.
   


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

Reply via email to