View Issue Details

IDProjectCategoryView StatusLast Update
0003640SymmetricDSImprovementpublic2018-08-03 14:12
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.9 
Target Version3.9.10Fixed in Version3.9.10 
Summary0003640: Oracle sequence noorder does not need extra index
DescriptionRemove the extra index on sym_data(create_time, data_id) that was added when oracle.sequence.noorder parameter is enabled. After more testing, the slowdown on DML to keep the index updated was not worth the improved performance of routing.
TagsNo tags attached.

Relationships

related to 0003586 closedelong Noorder sequence for performance on Oracle RAC 
related to 0003641 closedelong Oracle sequence noorder does not need extra index 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 fad81933

2018-07-20 12:16:06

admin

Details Diff
0003640: Oracle sequence noorder does not need extra index Affected Issues
0003640
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleSymmetricDialect.java Diff File

SymmetricDS: 3.9 4866b501

2018-07-20 12:19:26

admin

Details Diff
0003640: Oracle sequence noorder does not need extra index Affected Issues
0003640
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleSymmetricDialect.java Diff File

Issue History

Date Modified Username Field Change
2018-07-20 16:15 elong New Issue
2018-07-20 16:15 elong Status new => assigned
2018-07-20 16:15 elong Assigned To => elong
2018-07-20 16:15 elong Relationship added related to 0003586
2018-07-20 16:19 elong Status assigned => resolved
2018-07-20 16:19 elong Resolution open => fixed
2018-07-20 16:19 elong Fixed in Version => 3.9.10
2018-07-20 16:21 elong Relationship added related to 0003641
2018-07-20 17:00 admin Changeset attached => SymmetricDS 3.9 4866b501
2018-07-20 17:00 admin Changeset attached => SymmetricDS 3.9 fad81933
2018-08-03 14:12 chenson Status resolved => closed