View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0002524 | SymmetricDS | Improvement | public | 2016-03-15 19:11 | 2016-04-06 20:24 |
Reporter | elong | Assigned To | elong | ||
Priority | normal | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.7.31 | ||||
Target Version | 3.7.31 | Fixed in Version | 3.7.31 | ||
Summary | 0002524: Data gap detection slow when trying to expire gaps | ||||
Description | The data gap detection runs before routing to add new gaps of the data ID sequence, remove old gaps that have been routed, and expire gaps that don't have data. The expiration routine checks each gap against the sym_data table, but it should only query the database with that check if the gap has an expired create time. For Oracle, it also checks each gap with a query against the gv$transaction view, when it only needs query that view once for all gaps. | ||||
Tags | No tags attached. | ||||
SymmetricDS: 3.7 6fab9cfe 2016-03-15 15:13:07 Details Diff |
0002524: Data gap detection slow when trying to expire gaps |
Affected Issues 0002524 |
|
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleSymmetricDialect.java | Diff File | ||
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java | Diff File | ||
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/ISymmetricDialect.java | Diff File | ||
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/DataGapDetector.java | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2016-03-15 19:11 | elong | New Issue | |
2016-03-15 19:11 | elong | Status | new => assigned |
2016-03-15 19:11 | elong | Assigned To | => elong |
2016-03-15 20:00 | admin | Changeset attached | => SymmetricDS 3.7 6fab9cfe |
2016-04-05 20:43 | elong | Status | assigned => resolved |
2016-04-05 20:43 | elong | Fixed in Version | => 3.7.31 |
2016-04-05 20:43 | elong | Resolution | open => fixed |
2016-04-06 20:24 | admin | Status | resolved => closed |