View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004097 | SymmetricDS | New Feature | public | 2019-09-23 17:56 | 2019-11-15 14:04 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.0 | ||||
| Target Version | 3.11.0 | Fixed in Version | 3.11.0 | ||
| Summary | 0004097: Router convertToReload that converts multiple changes into a reload batch | ||||
| Description | When sub-setting with a subselect router is too slow, and there are too my tables or too many rows for a lookup router, the convertToReload router can help. It expects an expression of "temptable=mytemptable" where mytemptable is a table with the same primary key as the table where changes occur. The router will insert the rows that are changing into the temp table, then create a single reload batch with an initial load SQL statement that joins to the temp table. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.11 01a93ee5 2019-09-23 13:56:59 Details Diff |
0004097: Router convertToReload that converts multiple changes into a reload batch |
Affected Issues 0004097 |
|
| add - symmetric-core/src/main/java/org/jumpmind/symmetric/route/ConvertToReloadRouter.java | Diff File | ||
|
SymmetricDS: 3.11 942d9e1a 2019-09-23 13:57:23 Details Diff |
0004097: Router convertToReload that converts multiple changes into a reload batch |
Affected Issues 0004097 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/RouterService.java | Diff File | ||
|
SymmetricDS: 3.11 c58da503 2019-09-23 15:10:44 Details Diff |
0004097: Router convertToReload that converts multiple changes into a reload batch |
Affected Issues 0004097 |
|
| mod - symmetric-assemble/src/asciidoc/configuration/routers.ad | Diff File | ||
| add - symmetric-assemble/src/asciidoc/configuration/routers/convertToReload.ad | Diff File | ||
| mod - symmetric-assemble/src/asciidoc/configuration/routers/types.ad | Diff File | ||
|
SymmetricDS: 3.11 1848bbd2 2019-10-02 14:44:05 Details Diff |
0004097: use current transaction, single data_event, cache sorting tables, query for node list option, log stats |
Affected Issues 0004097 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/ConvertToReloadRouter.java | Diff File | ||
|
SymmetricDS: 3.11 085b7b17 2019-10-02 14:53:48 Details Diff |
0004097: remove sym_data_event.router_id |
Affected Issues 0004097 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/ConvertToReloadRouter.java | Diff File | ||
|
SymmetricDS: 3.11 6ebb2ff7 2019-10-03 13:49:25 Details Diff |
0004097: add transaction flush |
Affected Issues 0004097 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/ConvertToReloadRouter.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-09-23 17:56 | elong | New Issue | |
| 2019-09-23 17:56 | elong | Status | new => assigned |
| 2019-09-23 17:56 | elong | Assigned To | => elong |
| 2019-09-23 19:11 | elong | Status | assigned => resolved |
| 2019-09-23 19:11 | elong | Resolution | open => fixed |
| 2019-09-23 19:11 | elong | Fixed in Version | => 3.11.0 |
| 2019-09-27 21:00 | admin | Changeset attached | => SymmetricDS 3.11 c58da503 |
| 2019-09-27 21:00 | admin | Changeset attached | => SymmetricDS 3.11 942d9e1a |
| 2019-09-27 21:00 | admin | Changeset attached | => SymmetricDS 3.11 01a93ee5 |
| 2019-10-02 19:00 | admin | Changeset attached | => SymmetricDS 3.11 085b7b17 |
| 2019-10-02 19:00 | admin | Changeset attached | => SymmetricDS 3.11 1848bbd2 |
| 2019-10-03 18:00 | admin | Changeset attached | => SymmetricDS 3.11 6ebb2ff7 |
| 2019-11-15 14:04 | admin | Status | resolved => closed |