View Issue Details

IDProjectCategoryView StatusLast Update
0003823SymmetricDSImprovementpublic2018-12-07 16:00
ReportermmichalekAssigned Tommichalek 
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.9.0 
Target Version3.9.16Fixed in Version3.9.16 
Summary0003823: Improve performance and accuracy of DDL retrieval of Oracle Indexes
DescriptionThe "readIndecies" phase of loading a table on Oracle was found to take 1-2 seconds at times during Oracle testing. The slowness appears to be related to a NOT IN/subselect clause in the SQL reading the indexes.

The change here is to issue 2 separate queries to filter out the PK indexes from the list. This seems to show significant performance improvement (now readIndecies is taking 1-10 milliseconds instead of over 1 second).

Also changed this code to use ALL_INDEXES instead of USER_INDEXES so there is better chance for visibility on Indexes that aren't owned by the current user.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 967f7dd0

2018-12-07 15:54:22

mmichalek

Details Diff
0003823: Improve performance and accuracy of DDL retrieval of Oracle Indexes
0003823
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleDdlReader.java Diff File

Issue History

Date Modified Username Field Change
2018-12-07 15:51 mmichalek New Issue
2018-12-07 15:51 mmichalek Status new => assigned
2018-12-07 15:51 mmichalek Assigned To => mmichalek
2018-12-07 15:54 mmichalek Status assigned => resolved
2018-12-07 15:54 mmichalek Resolution open => fixed
2018-12-07 15:54 mmichalek Fixed in Version => 3.9.16
2018-12-07 16:00 mmichalek Changeset attached => SymmetricDS 3.9 967f7dd0