View Issue Details

IDProjectCategoryView StatusLast Update
0006943SymmetricDS ProImprovementpublic2025-07-10 17:14
Reporteremiller Assigned Toemiller  
Prioritylow 
Status closedResolutionfixed 
Product Version3.16.0 
Target Version3.16.4Fixed in Version3.16.4 
Summary0006943: Combine the Load Details screen's queries for complete and incomplete tables into one query
DescriptionCurrently, the Load Details screen uses two separate queries to retrieve rows from sym_extract_request: one where the loaded_time is null and another where the loaded_time is not null. It would improve performance if these two queries were combined into one query and the loaded_time was checked in memory instead.
Tagsinitial/partial load, performance, ui

Activities

emiller

2025-06-16 15:13

developer   ~0003095

Open-source PR: https://github.com/JumpMind/symmetric-ds/pull/299

pbelov

2025-07-10 17:14

manager   ~0003206

Included in the 3.16.4 release

Related Changesets

SymmetricDS: 3.16 1937a87d

2025-06-23 17:45:45

evan-miller-jumpmind


Committer: GitHub Details Diff
0006943: Combined the Load Details screen's queries for complete and incomplete tables into one query (#299) Affected Issues
0006943
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/model/ExtractRequest.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/IDataExtractorService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorServiceSqlMap.java Diff File

Issue History

Date Modified Username Field Change
2025-06-16 13:08 emiller New Issue
2025-06-16 13:08 emiller Status new => assigned
2025-06-16 13:08 emiller Assigned To => emiller
2025-06-16 13:08 emiller Tag Attached: initial/partial load
2025-06-16 13:08 emiller Tag Attached: performance
2025-06-16 13:08 emiller Tag Attached: ui
2025-06-16 15:13 emiller Note Added: 0003095
2025-06-23 17:46 pbelov Status assigned => resolved
2025-06-23 17:46 pbelov Resolution open => fixed
2025-06-23 17:46 pbelov Fixed in Version => 3.16.4
2025-06-23 18:00 Changeset attached => SymmetricDS 3.16 1937a87d
2025-07-10 17:14 pbelov Note Added: 0003206
2025-07-10 17:14 pbelov Status resolved => closed