Project

General

Profile

Task #1801

Feature #1781: libddbc修改,新增将表数据可以分多次获取的接口

测试mysql,oracle的大表加载效率

Added by pengfei xu about 3 years ago. Updated over 2 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Start date:
03/21/2022
Due date:
03/21/2022
% Done:

100%

Estimated time:
1.00 h
Defect version:

Description

由于mysql表结构扩大(64位)并加载大表(现场15号线数据),整个em_sys加载需要20+分钟以上,需要做效率测试(使用视图测试,sql测试);

测试mysql,oracle大表加载效率,对比视图效率;
为之后程序放弃使用视图,更改sql语句做数据支撑;

结果:
方案不好修改,最后决定吧libddbc读取数据库数据的内存扩大
由255600000 改为 536870911

History

#1

Updated by pengfei xu over 2 years ago

  • Due date set to 03/21/2022
  • Start date changed from 11/15/2021 to 03/21/2022
  • Estimated time set to 1.00 h
#2

Updated by pengfei xu over 2 years ago

  • Description updated (diff)
#3

Updated by pengfei xu over 2 years ago

  • Status changed from New to In Progress
#4

Updated by pengfei xu over 2 years ago

  • Status changed from In Progress to Resolved
#5

Updated by pengfei xu over 2 years ago

  • % Done changed from 0 to 100

Also available in: Atom PDF