Project

General

Profile

Feature #1781

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

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

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

100%

Estimated time:
(Total: 1.00 h)
Defect version:

Description

新增接口原因:
大平台升级到64位后表扩大,平台启动在读取相关表时由于数据过多导致内存区域不够;

修改方案:
在不扩大内存区域的基础上,当表数据量过大时,提供可以分多次获取相关数据的接口;将一张表的数据分多次获取;

方案问题:
简单使用limit功能,可能会出现数据重复问题(需要用主键排序);如果用主键排序limit,由于主键是char型,效率极低不如一次性读取;除非整体修改表结构(去除char主键改为索引,新增 自增IDint型主键)但会极大增加改造程序测试工作暂不考虑;
先将获取数据内存扩大,测试mysql及oracle大表加载效率,对比视图效率;


Subtasks

Task #1801: 测试mysql,oracle的大表加载效率Resolvedpengfei xu

Actions

History

#1

Updated by xiangyang li about 3 years ago

  • Target version set to 3.1
#2

Updated by pengfei xu about 3 years ago

  • Status changed from New to In Progress
#3

Updated by pengfei xu about 3 years ago

  • Description updated (diff)
#4

Updated by pengfei xu about 3 years ago

  • Description updated (diff)
#5

Updated by pengfei xu about 3 years ago

  • Description updated (diff)
#6

Updated by pengfei xu over 2 years ago

  • Status changed from In Progress to Resolved

Also available in: Atom PDF