View Issue Details

IDProjectCategoryView StatusLast Update
0001705SymmetricDSImprovementpublic2014-06-16 20:27
ReporterchensonAssigned Tochenson 
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Product Version3.6.0 
Target Version3.6.0Fixed in Version3.6.0 
Summary0001705: Improve initial load query performance
DescriptionInstead of issuing a query that formats and entire row of data in csv in the database, select the desired columns and do the csv work in code.

To turn this new feature on/off use initial.load.concat.csv.in.sql.enabled.

The feature will be turned on by default in 3.6.
TagsNo tags attached.

Activities

chenson

2014-05-09 11:47

administrator   ~0000518

This feature was added to 3.5.22 and disabled by default.

Related Changesets

SymmetricDS: master 5c7460d2

2014-04-30 20:06:08

chenson

Details Diff
0001705: Improve initial load query performance
0001705
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql2000/MsSql2000TriggerTemplate.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/route/ConfigurationChangedDataRouter.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/RouterService.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File
mod - symmetric-core/src/test/java/org/jumpmind/symmetric/service/impl/AbstractTriggerRouterServiceTest.java Diff File

SymmetricDS: master 2d24f7c7

2014-04-30 21:23:34

chenson

Details Diff
0001705: Improve initial load query performance
0001705
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java Diff File

SymmetricDS: master 1f9467d6

2014-05-12 08:55:54

chenson

Details Diff
0001705: Improve initial load query performance
0001705
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractTriggerTemplate.java Diff File

Issue History

Date Modified Username Field Change
2014-04-30 20:05 chenson New Issue
2014-04-30 20:05 chenson Status new => assigned
2014-04-30 20:05 chenson Assigned To => chenson
2014-04-30 20:07 chenson Status assigned => resolved
2014-04-30 20:07 chenson Fixed in Version => 3.6.0
2014-04-30 20:07 chenson Resolution open => fixed
2014-04-30 21:00 Changeset attached => SymmetricDS trunk r8216
2014-04-30 22:00 Changeset attached => SymmetricDS trunk r8217
2014-05-09 11:47 chenson Note Added: 0000518
2014-05-09 12:00 Changeset attached => SymmetricDS 3.5 r8249
2014-05-12 09:00 Changeset attached => SymmetricDS trunk r8259
2014-05-12 09:00 Changeset attached => SymmetricDS 3.5 r8260
2014-06-16 20:27 chenson Status resolved => closed
2015-07-30 21:49 chenson Changeset attached => SymmetricDS master 1f9467d6
2015-07-30 21:49 chenson Changeset attached => SymmetricDS master 2d24f7c7
2015-07-30 21:49 chenson Changeset attached => SymmetricDS master 5c7460d2