View Issue Details

IDProjectCategoryView StatusLast Update
0002702SymmetricDSImprovementpublic2016-08-09 13:10
ReporterelongAssigned Toelong 
PrioritynormalSeverityminorReproducibilityN/A
Status closedResolutionfixed 
Product Version3.8.0 
Target Version3.8.0Fixed in Version3.8.0 
Summary0002702: High CPU usage from Table.getFullyQualifiedTableName()
DescriptionThe Table.getFullyQualifiedTableName() is showing up in a VisualVM profiler report as using 59% of CPU time sampled. It does multiple string concatenations, which is called from heavy looping classes like the DefaultDatabaseWriter where it is called for each row of data that is loaded. Reduce CPU usage by using StringBuilder and caching the results in the Table object itself.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 8e3166da

2016-08-02 21:04:11

admin

Details Diff
0002702: High CPU usage from Table.getFullyQualifiedTableName()
0002702
mod - symmetric-db/src/main/java/org/jumpmind/db/model/Table.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DatabaseWriterSettings.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/TransformWriter.java Diff File

Issue History

Date Modified Username Field Change
2016-08-02 21:03 elong New Issue
2016-08-02 21:03 elong Status new => assigned
2016-08-02 21:03 elong Assigned To => elong
2016-08-02 21:05 elong Status assigned => closed
2016-08-02 21:05 elong Resolution open => fixed
2016-08-02 21:05 elong Fixed in Version => 3.8.0
2016-08-02 21:05 elong Status closed => feedback
2016-08-02 21:05 elong Resolution fixed => reopened
2016-08-02 21:05 elong Status feedback => resolved
2016-08-02 21:05 elong Resolution reopened => fixed
2016-08-02 22:00 admin Changeset attached => SymmetricDS 3.8 8e3166da
2016-08-09 13:10 admin Status resolved => closed