View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004186 | SymmetricDS | Improvement | public | 2019-12-05 18:03 | 2019-12-09 17:27 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.0 | ||||
| Target Version | 3.11.2 | Fixed in Version | 3.11.2 | ||
| Summary | 0004186: Node communication query for unsent batches not using index on Oracle | ||||
| Description | When 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'); | ||||
| Tags | No tags attached. | ||||
| 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 |