View Issue Details

IDProjectCategoryView StatusLast Update
0003817SymmetricDSImprovementpublic2018-12-06 14:00
ReporterelongAssigned Toelong 
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.10.0 
Target Version3.10.0Fixed in Version3.10.0 
Summary0003817: Initial load use estimated counts
DescriptionThe 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.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 29f29b07

2018-12-06 11:12:35

admin

Details Diff
0003817: Initial load use estimated counts
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

admin

Details Diff
0003817: Initial load use estimated counts
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

admin

Details Diff
0003817: Initial load use estimated counts
0003817
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File

SymmetricDS: 3.10 ff8b6333

2018-12-06 13:19:58

admin

Details Diff
0003817: Initial load use estimated counts
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

Issue History

Date Modified Username Field Change
2018-12-06 11:06 elong New Issue
2018-12-06 11:06 elong Status new => assigned
2018-12-06 11:06 elong Assigned To => elong
2018-12-06 13:00 admin Changeset attached => SymmetricDS 3.10 10cbda70
2018-12-06 13:00 admin Changeset attached => SymmetricDS 3.10 74f75f85
2018-12-06 13:00 admin Changeset attached => SymmetricDS 3.10 29f29b07
2018-12-06 13:20 elong Status assigned => resolved
2018-12-06 13:20 elong Resolution open => fixed
2018-12-06 13:20 elong Fixed in Version => 3.10.0
2018-12-06 14:00 admin Changeset attached => SymmetricDS 3.10 ff8b6333