View Issue Details

IDProjectCategoryView StatusLast Update
0003641SymmetricDSImprovementpublic2018-07-23 11:13
ReporterelongAssigned Toelong 
Prioritynormal 
Status closedResolutionfixed 
Product Version3.8.36 
Target Version3.8.37Fixed in Version3.8.37 
Summary0003641: 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.

Relationships

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

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 0f0c44c8

2018-07-20 12:22:26

admin

Details Diff
0003641: Oracle sequence noorder does not need extra index
0003641
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 12:20 elong New Issue
2018-07-20 12:20 elong Status new => assigned
2018-07-20 12:20 elong Assigned To => elong
2018-07-20 12:21 elong Relationship added related to 0003640
2018-07-20 12:21 elong Relationship added related to 0003586
2018-07-20 12:22 elong Status assigned => resolved
2018-07-20 12:22 elong Resolution open => fixed
2018-07-20 12:22 elong Fixed in Version => 3.8.37
2018-07-20 13:00 admin Changeset attached => SymmetricDS 3.8 0f0c44c8
2018-07-23 11:13 mmichalek Status resolved => closed