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 2021/11/30 06:10:56 UTC

[GitHub] [dolphinscheduler] janeHe13 opened a new issue #7061: [Bug] [dolphinscheduler-api] The pages of project management, workflow instance and task instance are accessed slowly

janeHe13 opened a new issue #7061:
URL: https://github.com/apache/dolphinscheduler/issues/7061


   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### What happened
   
   The pages of project management, workflow instance and task instance are accessed slowly
   ![image](https://user-images.githubusercontent.com/95271106/143994546-7125905d-b772-4a75-bcf1-91573804387b.png)
   
   
   ### What you expected to happen
   
   When the amount of data is large, the SQL query statement is slow
   
   
   
   
   ### How to reproduce
   
   Optimize SQL query statements
   
   
   ### Anything else
   
   _No response_
   
   ### Version
   
   2.0.0
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


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



[GitHub] [dolphinscheduler] CalvinKirs closed issue #7061: [Bug] [dolphinscheduler-api] The pages of project management, workflow instance and task instance are accessed slowly

Posted by GitBox <gi...@apache.org>.
CalvinKirs closed issue #7061:
URL: https://github.com/apache/dolphinscheduler/issues/7061


   


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



[GitHub] [dolphinscheduler] zhongjiajie commented on issue #7061: [Bug] [dolphinscheduler-api] The pages of project management, workflow instance and task instance are accessed slowly

Posted by GitBox <gi...@apache.org>.
zhongjiajie commented on issue #7061:
URL: https://github.com/apache/dolphinscheduler/issues/7061#issuecomment-984350598


   Hi @janeHe13, we plan to inspect and fix this issue in 2.0.2, if you want to join our community, maybe you could try to fix it by yourself.


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



[GitHub] [dolphinscheduler] GaoTianDuo commented on issue #7061: [Bug] [dolphinscheduler-api] The pages of project management, workflow instance and task instance are accessed slowly

Posted by GitBox <gi...@apache.org>.
GaoTianDuo commented on issue #7061:
URL: https://github.com/apache/dolphinscheduler/issues/7061#issuecomment-984674308


   I found that the SQL behind this interface is very slow. The main table is large, but there is no index to use. By add the index, the all mode in the query plan can be changed into a more efficient ref mode. If this optimization still fails to meet the requirements, please contact me and I will continue to optimize。


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



[GitHub] [dolphinscheduler] GaoTianDuo commented on issue #7061: [Bug] [dolphinscheduler-api] The pages of project management, workflow instance and task instance are accessed slowly

Posted by GitBox <gi...@apache.org>.
GaoTianDuo commented on issue #7061:
URL: https://github.com/apache/dolphinscheduler/issues/7061#issuecomment-984639783


   I want to fix it.


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



[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #7061: [Bug] [dolphinscheduler-api] The pages of project management, workflow instance and task instance are accessed slowly

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #7061:
URL: https://github.com/apache/dolphinscheduler/issues/7061#issuecomment-982318741


   Hi:
   * Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
   * In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
   * If you haven't received a reply for a long time, you can subscribe to the developer's email,Mail subscription steps reference https://dolphinscheduler.apache.org/en-us/community/development/subscribe.html ,Then write the issue URL in the email content and send question to dev@dolphinscheduler.apache.org.


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