apache / dolphinscheduler

Apache DolphinScheduler is the modern data orchestration platform. Agile to create high performance workflow with low-code
https://dolphinscheduler.apache.org/
Apache License 2.0
12.73k stars 4.58k forks source link

[Feature][dolphinscheduler ui] Add a default time interval to the workflow/task instance list in the project #16626

Closed iouAkira closed 1 week ago

iouAkira commented 1 week ago

Search before asking

Description

项目里面工作流/任务实例列表对应数据库表单个项目内的任务实例超500W的时候,任务实例页面打开就超时,因为默认没有fillter 只有项目code,要做全量排序分页,接口请求都会超时,建议增加 默认的任务实例查询区间,例如:默认时间区间就是近一周,整体查询效率就会比较高

Use case

No response

Related issues

No response

Are you willing to submit a PR?

Code of Conduct

github-actions[bot] commented 1 week ago

Search before asking

Description

When the workflow/task instance list in the project corresponds to the database table and the task instances in a single project exceed 5 million, the task instance page will time out when opening, because there is no fillter by default and only the project code. To do full sorting and paging, the interface request will time out. It is recommended to add The default task instance query interval, for example: the default time interval is the past week, the overall query efficiency will be higher

Use case

No response

Related issues

No response

Are you willing to submit a PR?

Code of Conduct

SbloodyS commented 1 week ago

Please use english to describe.

iouAkira commented 1 week ago

😂原来dolphinscheduler 限制中文issue,没事啦,我自己本地调整编译解决自己需求啦