View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003802 | SymmetricDS | Improvement | public | 2018-11-21 19:41 | 2019-03-14 12:48 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.10.0 | ||||
| Target Version | 3.10.0 | Fixed in Version | 3.10.0 | ||
| Summary | 0003802: Faster two-pass initial load for tables with LOB on Oracle | ||||
| Description | During initial load on Oracle or Tibero, extract tables with LOBs using two passes across the table. The first pass gets rows where the LOBs are length 4000 or less, performing a substring for the first 4000 characters. These rows will extract very fast and stay within the SQL limit for a VARCHAR. The second pass gets the rows where any of the LOBs are length over 4000, performing the slower LOB retrieval. Parameter driven just in case it needs disabled: initial.load.extract.use.two.pass.lob=true | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.10 98deedd2 2018-11-21 14:58:13 Details Diff |
0003802: Faster two-pass initial load for tables with LOB on Oracle |
Affected Issues 0003802 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleSymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/tibero/TiberoSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractTriggerTemplate.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/ISymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java | Diff File | ||
| mod - symmetric-core/src/main/resources/symmetric-default.properties | Diff File | ||
|
SymmetricDS: 3.10 e04c07b6 2018-12-05 16:40:15 Details Diff |
0003802: Faster two-pass initial load for tables with LOB on Oracle |
Affected Issues 0003802 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleSymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/tibero/TiberoSymmetricDialect.java | Diff File | ||
|
SymmetricDS: 3.10 6aa39c62 2018-12-05 16:40:58 Details Diff |
0003802: Faster two-pass initial load for tables with LOB on Oracle |
Affected Issues 0003802 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java | Diff File | ||
|
SymmetricDS: 3.10 eb1fefa4 2018-12-20 10:27:01 Details Diff |
0003802: Faster two-pass initial load for tables with LOB on Oracle |
Affected Issues 0003802 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java | Diff File | ||
|
SymmetricDS: 3.10 ebab3478 2019-03-11 08:44:15 Details Diff |
0003802: Faster two-pass initial load for tables with LOB on Oracle |
Affected Issues 0003802 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleSymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/tibero/TiberoSymmetricDialect.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-11-21 19:41 | elong | New Issue | |
| 2018-11-21 19:41 | elong | Status | new => assigned |
| 2018-11-21 19:41 | elong | Assigned To | => elong |
| 2018-11-21 19:59 | elong | Status | assigned => resolved |
| 2018-11-21 19:59 | elong | Resolution | open => fixed |
| 2018-11-21 19:59 | elong | Fixed in Version | => 3.10.0 |
| 2018-11-28 16:00 | admin | Changeset attached | => SymmetricDS 3.10 98deedd2 |
| 2018-12-06 18:00 | admin | Changeset attached | => SymmetricDS 3.10 6aa39c62 |
| 2018-12-06 18:00 | admin | Changeset attached | => SymmetricDS 3.10 e04c07b6 |
| 2018-12-20 16:00 | elong | Changeset attached | => SymmetricDS 3.10 eb1fefa4 |
| 2019-03-11 13:00 | admin | Changeset attached | => SymmetricDS 3.10 ebab3478 |
| 2019-03-14 12:48 | admin | Status | resolved => closed |