View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004175 | SymmetricDS | Improvement | public | 2019-12-02 18:51 | 2020-01-02 15:00 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.10.0 | ||||
| Target Version | 3.10.7 | Fixed in Version | 3.10.7 | ||
| Summary | 0004175: 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 | dialect: oracle, performance | ||||
|
SymmetricDS: 3.8 78c58183 2019-12-02 14:07:43 Details Diff |
0004175: Node communication query for unsent batches not using index on Oracle |
Affected Issues 0004175 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/NodeCommunicationService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/NodeCommunicationServiceSqlMap.java | Diff File | ||
|
SymmetricDS: 3.10 2425afa7 2019-12-02 14:07:43 Details Diff |
0004175: Node communication query for unsent batches not using index on Oracle |
Affected Issues 0004175 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/NodeCommunicationService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/NodeCommunicationServiceSqlMap.java | Diff File | ||
|
SymmetricDS: 3.8 a2702cdc 2019-12-03 12:35:28 Details Diff |
0004175: Node communication query for unsent batches not using index on Oracle |
Affected Issues 0004175 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/NodeCommunicationService.java | Diff File | ||
|
SymmetricDS: 3.10 98f1cd21 2019-12-03 12:35:28 Details Diff |
0004175: Node communication query for unsent batches not using index on Oracle |
Affected Issues 0004175 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/NodeCommunicationService.java | Diff File | ||
|
SymmetricDS: 3.11 f705488c 2019-12-03 12:35:28 Details Diff |
0004175: Node communication query for unsent batches not using index on Oracle |
Affected Issues 0004175 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/NodeCommunicationService.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-12-02 18:51 | elong | New Issue | |
| 2019-12-02 18:51 | elong | Status | new => assigned |
| 2019-12-02 18:51 | elong | Assigned To | => elong |
| 2019-12-02 18:52 | elong | Relationship added | related to 0003227 |
| 2019-12-02 18:52 | elong | Tag Attached: dialect: oracle | |
| 2019-12-02 18:52 | elong | Tag Attached: performance | |
| 2019-12-02 19:08 | admin | Changeset attached | => SymmetricDS 3.8 78c58183 |
| 2019-12-03 18:00 | admin | Changeset attached | => SymmetricDS 3.8 a2702cdc |
| 2019-12-05 18:03 | elong | Status | assigned => resolved |
| 2019-12-05 18:03 | elong | Resolution | open => fixed |
| 2019-12-05 18:03 | elong | Product Version | 3.8.30 => 3.10.0 |
| 2019-12-05 18:03 | elong | Fixed in Version | => 3.10.7 |
| 2019-12-05 18:03 | elong | Target Version | => 3.10.7 |
| 2019-12-05 18:03 | elong | Issue cloned: 0004186 | |
| 2019-12-05 18:03 | elong | Relationship added | related to 0004186 |
| 2019-12-05 19:00 | admin | Changeset attached | => SymmetricDS 3.10 2425afa7 |
| 2019-12-09 17:26 | admin | Status | resolved => closed |
| 2020-01-02 15:00 | admin | Changeset attached | => SymmetricDS 3.10 98f1cd21 |
| 2020-01-02 15:00 | admin | Changeset attached | => SymmetricDS 3.11 f705488c |