This is an automated email from the ASF dual-hosted git repository.
lidongdai pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/incubator-dolphinscheduler.git
The following commit(s) were added to refs/heads/dev by this push:
new d565892 fixed queryProcessInstanceListPaging query slow (#3893)
d565892 is described below
commit d56589260b1f4f55ae11f8db905b88063c77fc66
Author: 小清 <[email protected]>
AuthorDate: Sat Oct 17 21:14:33 2020 +0800
fixed queryProcessInstanceListPaging query slow (#3893)
because queryProcessInstanceListPaging has contain longtext type field by
instance.*,so queryProcessInstanceListPaging query slow , but longtext field
not used.
---
.../apache/dolphinscheduler/dao/mapper/ProcessInstanceMapper.xml | 7 +++++--
1 file changed, 5 insertions(+), 2 deletions(-)
diff --git
a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProcessInstanceMapper.xml
b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProcessInstanceMapper.xml
index 83864b5..1e201fe 100644
---
a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProcessInstanceMapper.xml
+++
b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProcessInstanceMapper.xml
@@ -76,7 +76,10 @@
</select>
<select id="queryProcessInstanceListPaging"
resultType="org.apache.dolphinscheduler.dao.entity.ProcessInstance">
- select instance.*
+ select
instance.id,instance.name,instance.process_definition_id,instance.state,instance.recovery,instance.start_time,instance.end_time,instance.run_times,instance.host,instance.command_type,instance.command_param,
+
instance.task_depend_type,instance.max_try_times,instance.failure_strategy,instance.warning_type,instance.warning_group_id,instance.schedule_time,instance.command_start_time,instance.global_params,instance.flag,
+
instance.update_time,instance.is_sub_process,instance.executor_id,instance.locations,instance.connects,instance.history_cmd,instance.dependence_schedule_times,instance.process_instance_priority,instance.worker_group,
+ instance.timeout,instance.tenant_id
from t_ds_process_instance instance
join t_ds_process_definition define ON instance.process_definition_id
= define.id
where 1=1
@@ -202,4 +205,4 @@
order by id asc
</select>
-</mapper>
\ No newline at end of file
+</mapper>
