View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003833 | SymmetricDS | Improvement | public | 2018-12-17 15:48 | 2019-03-14 12:48 |
| Reporter | mmichalek | Assigned To | mmichalek | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.10.0 | ||||
| Target Version | 3.10.0 | Fixed in Version | 3.10.0 | ||
| Summary | 0003833: Improve performance and accuracy of DDL retrieval of Oracle Indexes (3.10) | ||||
| Description | The "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. | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-12-17 15:48 | mmichalek | New Issue | |
| 2018-12-17 15:48 | mmichalek | Status | new => assigned |
| 2018-12-17 15:48 | mmichalek | Assigned To | => mmichalek |
| 2018-12-17 15:48 | mmichalek | Issue generated from: 0003823 | |
| 2018-12-17 15:48 | mmichalek | Relationship added | related to 0003823 |
| 2018-12-17 15:48 | mmichalek | Status | assigned => resolved |
| 2018-12-17 15:48 | mmichalek | Resolution | open => fixed |
| 2018-12-17 15:48 | mmichalek | Fixed in Version | => 3.10.0 |
| 2019-03-14 12:48 | admin | Status | resolved => closed |