View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002682 | SymmetricDS | Improvement | public | 2016-07-17 14:09 | 2016-08-09 17:10 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.0 | ||||
| Target Version | 3.8.0 | Fixed in Version | 3.8.0 | ||
| Summary | 0002682: Cache outgoing batch sequences | ||||
| Description | The sequence service gives out each sequence number for outgoing batches, outgoing loads, and trigger history. It uses the sym_sequence table, so it needs to query the table and then attempt to update it each time. Add a cache_size column that indicates to retrieve and cache a number of IDs at once. On upgrade to 3.8, update the cache_size for outgoing batches to use 10. When a sequence is requested, it will update the table to push the sequence ahead by 10, return the first sequence to the caller, and cache the remaining 9 to hand out without using the database. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.8 51f58fef 2016-07-17 10:26:11 Details Diff |
0002682: Cache outgoing batch sequences |
Affected Issues 0002682 |
|
| mod - symmetric-client/src/main/resources/symmetric-ext-points.xml | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/model/Sequence.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/SequenceService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/SequenceServiceSqlMap.java | Diff File | ||
| mod - symmetric-core/src/main/resources/symmetric-schema.xml | Diff File | ||
|
SymmetricDS: 3.8 6802e594 2016-07-17 10:27:02 Details Diff |
0002682: Cache outgoing batch sequences |
Affected Issues 0002682 |
|
| add - symmetric-core/src/main/java/org/jumpmind/symmetric/db/DatabaseUpgradeListener.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/SequenceService.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-07-17 14:09 | elong | New Issue | |
| 2016-07-17 14:09 | elong | Status | new => assigned |
| 2016-07-17 14:09 | elong | Assigned To | => elong |
| 2016-07-17 14:27 | elong | Status | assigned => resolved |
| 2016-07-17 14:27 | elong | Fixed in Version | => 3.8.0 |
| 2016-07-17 14:27 | elong | Resolution | open => fixed |
| 2016-07-17 15:00 | admin | Changeset attached | => SymmetricDS 3.8 6802e594 |
| 2016-07-17 15:00 | admin | Changeset attached | => SymmetricDS 3.8 51f58fef |
| 2016-08-09 17:10 | admin | Status | resolved => closed |