View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003136 | SymmetricDS Pro | Bug | public | 2017-06-02 17:41 | 2018-02-14 20:08 |
| Reporter | chenson | Assigned To | chenson | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.24 | ||||
| Target Version | 3.8.25 | Fixed in Version | 3.8.25 | ||
| Summary | 0003136: The load summary page is slow because of unused joins to sym_data | ||||
| Description | The load summary page is slow because of unused joins to sym_data. 2017-06-02 13:23:57,420 INFO [gui] [JdbcSqlTemplate] [http-nio-8080-exec-6] Long Running: (27793ms.) select b.load_id, b.node_id, b.status, b.create_by, max(error_flag) as error_flag, count(*) as cnt, min(b.create_time) as create_time, max(b.last_update_time) as last_update_time, min(b.batch_id) as current_batch_id, min(b.data_event_count) as current_data_event_count, b.channel_id from sym_outgoing_batch b inner join sym_data_event e on b.batch_id=e.batch_id inner join sym_data d on d.data_id=e.data_id join sym_channel c on c.channel_id = b.channel_id where c.reload_flag = 1 and b.load_id > 0 group by b.load_id, b.node_id, b.status, b.channel_id, b.create_by order by b.load_id desc 2017-06-02 13:24:22,558 INFO [gui] [JdbcSqlTemplate] [http-nio-8080-exec-6] Long Running: (25131ms.) select b.load_id, b.node_id, b.status, b.create_by, max(error_flag) as error_flag, count(*) as cnt, min(b.create_time) as create_time, max(b.last_update_time) as last_update_time, min(b.batch_id) as current_batch_id, min(b.data_event_count) as current_data_event_count, b.channel_id from sym_outgoing_batch b inner join sym_data_event e on b.batch_id=e.batch_id inner join sym_data d on d.data_id=e.data_id join sym_channel c on c.channel_id = b.channel_id where c.reload_flag = 1 and b.load_id > 0 group by b.load_id, b.node_id, b.status, b.channel_id, b.create_by order by b.load_id desc 2017-06-02 13:24:47,687 INFO [gui] [JdbcSqlTemplate] [http-nio-8080-exec-6] Long Running: (25126ms.) select b.load_id, b.node_id, b.status, b.create_by, max(error_flag) as error_flag, count(*) as cnt, min(b.create_time) as create_time, max(b.last_update_time) as last_update_time, min(b.batch_id) as current_batch_id, min(b.data_event_count) as current_data_event_count, b.channel_id from sym_outgoing_batch b inner join sym_data_event e on b.batch_id=e.batch_id inner join sym_data d on d.data_id=e.data_id join sym_channel c on c.channel_id = b.channel_id where c.reload_flag = 1 and b.load_id > 0 group by b.load_id, b.node_id, b.status, b.channel_id, b.create_by order by b.load_id desc 2017-06-02 13:25:16,283 INFO [gui] [JdbcSqlTemplate] [http-nio-8080-exec-6] Long Running: (28592ms.) select b.load_id, b.node_id, b.status, b.create_by, max(error_flag) as error_flag, count(*) as cnt, min(b.create_time) as create_time, max(b.last_update_time) as last_update_time, min(b.batch_id) as current_batch_id, min(b.data_event_count) as current_data_event_count, b.channel_id from sym_outgoing_batch b inner join sym_data_event e on b.batch_id=e.batch_id inner join sym_data d on d.data_id=e.data_id join sym_channel c on c.channel_id = b.channel_id where c.reload_flag = 1 and b.load_id > 0 group by b.load_id, b.node_id, b.status, b.channel_id, b.create_by order by b.load_id desc | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.8 b1c19a3a 2017-06-02 13:42:01 Details Diff |
0003136: The load summary page is slow because of unused joins to sym_data |
Affected Issues 0003136 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/OutgoingBatchServiceSqlMap.java | Diff File | ||
|
SymmetricDS: 3.9 c599789a 2017-06-02 13:52:06 Details Diff |
0003136: The load summary page is slow because of unused joins to sym_data |
Affected Issues 0003136 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/OutgoingBatchServiceSqlMap.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-06-02 17:41 | chenson | New Issue | |
| 2017-06-02 17:41 | chenson | Status | new => assigned |
| 2017-06-02 17:41 | chenson | Assigned To | => chenson |
| 2017-06-02 17:42 | chenson | Status | assigned => resolved |
| 2017-06-02 17:42 | chenson | Fixed in Version | => 3.8.25 |
| 2017-06-02 17:42 | chenson | Resolution | open => fixed |
| 2017-06-02 18:00 | chenson42 | Changeset attached | => SymmetricDS 3.8 b1c19a3a |
| 2017-06-05 13:09 | chenson | Status | resolved => closed |
| 2018-02-14 20:08 | chenson42 | Changeset attached | => SymmetricDS 3.9 c599789a |