Project

General

Profile

Feature #304

mysql 批量插入效率太低,需要优化

Added by xiangyang li over 4 years ago. Updated over 4 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Target version:
Start date:
10/23/2019
Due date:
% Done:

100%

Estimated time:
Defect version:

Description

InsertRcd 使用的是超长的一条insert语句,在备份实时表数据时效率非常低,会卡住,需要优化。

History

#1

Updated by xiangyang li over 4 years ago

  • Status changed from New to In Progress
  • Assignee set to xiangyang li
#2

Updated by xiangyang li over 4 years ago

  • Status changed from In Progress to Resolved
  • % Done changed from 0 to 100

改为循环插入方式,测试结果看满足备份要求。

Also available in: Atom PDF