View Issue Details

IDProjectCategoryView StatusLast Update
0002682SymmetricDSImprovementpublic2016-08-09 13:10
ReporterelongAssigned Toelong 
PrioritynormalSeverityminorReproducibilityN/A
Status closedResolutionfixed 
Product Version3.8.0 
Target Version3.8.0Fixed in Version3.8.0 
Summary0002682: Cache outgoing batch sequences
DescriptionThe 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.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 51f58fef

2016-07-17 10:26:11

admin

Details Diff
0002682: Cache outgoing batch sequences
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

admin

Details Diff
0002682: Cache outgoing batch sequences
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

Issue History

Date Modified Username Field Change
2016-07-17 10:09 elong New Issue
2016-07-17 10:09 elong Status new => assigned
2016-07-17 10:09 elong Assigned To => elong
2016-07-17 10:27 elong Status assigned => resolved
2016-07-17 10:27 elong Fixed in Version => 3.8.0
2016-07-17 10:27 elong Resolution open => fixed
2016-07-17 11:00 admin Changeset attached => SymmetricDS 3.8 6802e594
2016-07-17 11:00 admin Changeset attached => SymmetricDS 3.8 51f58fef
2016-08-09 13:10 admin Status resolved => closed