View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003817 | SymmetricDS | Improvement | public | 2018-12-06 16:06 | 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 | 0003817: Initial load use estimated counts | ||||
| Description | The initial load generates multiple batches for a table by counting the rows and dividing by the max_batch_size of the channel. On a large database, the "select count(*) from table" can take a long time. Instead, ask the database platform to get an estimated count for the table, which is faster. Platforms with an easy implementation are Oracle, PostgreSQL, MySQL, and SQL-Server. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.10 29f29b07 2018-12-06 11:12:35 Details Diff |
0003817: Initial load use estimated counts |
Affected Issues 0003817 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/IDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mysql/MySqlDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDatabasePlatform.java | Diff File | ||
|
SymmetricDS: 3.10 74f75f85 2018-12-06 12:25:34 Details Diff |
0003817: Initial load use estimated counts |
Affected Issues 0003817 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java | Diff File | ||
|
SymmetricDS: 3.10 10cbda70 2018-12-06 12:25:50 Details Diff |
0003817: Initial load use estimated counts |
Affected Issues 0003817 |
|
| mod - symmetric-core/src/main/resources/symmetric-default.properties | Diff File | ||
|
SymmetricDS: 3.10 ff8b6333 2018-12-06 13:19:58 Details Diff |
0003817: Initial load use estimated counts |
Affected Issues 0003817 |
|
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSql2008DatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/tibero/TiberoDatabasePlatform.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-12-06 16:06 | elong | New Issue | |
| 2018-12-06 16:06 | elong | Status | new => assigned |
| 2018-12-06 16:06 | elong | Assigned To | => elong |
| 2018-12-06 18:00 | admin | Changeset attached | => SymmetricDS 3.10 10cbda70 |
| 2018-12-06 18:00 | admin | Changeset attached | => SymmetricDS 3.10 74f75f85 |
| 2018-12-06 18:00 | admin | Changeset attached | => SymmetricDS 3.10 29f29b07 |
| 2018-12-06 18:20 | elong | Status | assigned => resolved |
| 2018-12-06 18:20 | elong | Resolution | open => fixed |
| 2018-12-06 18:20 | elong | Fixed in Version | => 3.10.0 |
| 2018-12-06 19:00 | admin | Changeset attached | => SymmetricDS 3.10 ff8b6333 |
| 2019-01-14 18:17 | elong | Relationship added | related to 0003854 |
| 2019-03-14 12:48 | admin | Status | resolved => closed |