View Issue Details

IDProjectCategoryView StatusLast Update
0004186SymmetricDSImprovementpublic2019-12-09 17:27
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.11.0 
Target Version3.11.2Fixed in Version3.11.2 
Summary0004186: Node communication query for unsent batches not using index on Oracle
DescriptionWhen pushing to a large number of nodes, the node communication service will query for nodes that has unsent batches.

select distinct(node_id) from sym_outgoing_batch where status <> 'OK';

On Oracle, a not-equals will not use the index. Instead, we should query like this:

select distinct(node_id) from sym_outgoing_batch where status in ('ER','NE','QY','SE','LD','IG','RS');
TagsNo tags attached.

Relationships

related to 0004175 closedelong Node communication query for unsent batches not using index on Oracle 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-12-05 18:03 elong New Issue
2019-12-05 18:03 elong Status new => assigned
2019-12-05 18:03 elong Assigned To => elong
2019-12-05 18:03 elong Issue generated from: 0004175
2019-12-05 18:03 elong Relationship added related to 0004175
2019-12-05 18:05 elong Status assigned => resolved
2019-12-05 18:05 elong Resolution open => fixed
2019-12-05 18:05 elong Fixed in Version => 3.11.2
2019-12-09 17:27 admin Status resolved => closed