Project

General

Profile

Bug #103

PA插件打开后在高频次50ms的SQL查询实时库,抓紧优化处理

Added by yufeng wu over 5 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
High
Assignee:
Target version:
Start date:
05/23/2019
Due date:
05/30/2019
% Done:

100%

Estimated time:
Defect version:

Description

客户SQL访问服务器表:select PointCode,Value from digital where AppSysId = 11PID:17384


Related issues

Copied to ISCS#FEP - Feature #138: in_paC3L4获取车站通道状态效率优化Closed06/13/201906/14/2019

Actions

History

#1

Updated by yufeng wu over 5 years ago

yufeng wu wrote:

客户SQL访问服务器表:select PointCode,Value from digital where AppSysId = 11PID:17384

PAUISet.ini的ValueFlushMilliseconds可以配置的,
建议不要用SQL查询实时库,可以改成CRdbSrvAccess的GetColIntVal根据点代码精确获取

#2

Updated by xiangyang li over 5 years ago

  • Assignee set to jiwei shi
#3

Updated by xiangyang li over 5 years ago

  • Due date set to 05/30/2019
  • Target version set to 2.1
#4

Updated by jiwei shi over 5 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

PA获取车站通道状态方式从SQL查询实时库更改为CRdbCltAccess的接口SendGetDataPara定点获取;

#5

Updated by xiangyang li over 5 years ago

  • Copied to Feature #138: in_paC3L4获取车站通道状态效率优化 added
#6

Updated by xiangyang li over 5 years ago

  • Target version changed from 2.1 to 2.2.1
#7

Updated by xiangyang li over 4 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF