View Issue Details

IDProjectCategoryView StatusLast Update
0007000SymmetricDSImprovementpublic2025-08-07 15:49
Reporteremiller Assigned Toemiller  
Priorityhigh 
Status closedResolutionfixed 
Product Version3.16.0 
Target Version3.16.5Fixed in Version3.16.5 
Summary0007000: Cache the lists of table names in each catalog/schema in the DDL reader
DescriptionCurrently, the lists of table names in each catalog/schema are not cached, so every time SymmetricDS needs one of the lists, it queries the database. Instead, the lists should be cached in the DDL reader in order to improve performance.
TagsNo tags attached.

Activities

emiller

2025-07-22 15:09

developer   ~0003263

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

pbelov

2025-08-07 15:49

manager   ~0003297

Included in the 3.16.5 release

Related Changesets

SymmetricDS: 3.16 9687f898

2025-07-28 15:15:41

evan-miller-jumpmind


Committer: GitHub Details Diff
0007000: Cached the lists of table names in each catalog/schema in the DDL reader (#331)

* 0007000: Cached the lists of table names in each catalog/schema in the DDL reader
Affected Issues
0007000
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java Diff File
add - symmetric-jdbc/src/main/java/org/jumpmind/cache/ObjectDefinitionCache.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDatabasePlatform.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSqlDdlReader.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleDdlReader.java Diff File
add - symmetric-jdbc/src/test/java/org/jumpmind/cache/ObjectDefinitionCacheTest.java Diff File

Issue History

Date Modified Username Field Change
2025-07-21 16:53 emiller New Issue
2025-07-21 16:53 emiller Status new => assigned
2025-07-21 16:53 emiller Assigned To => emiller
2025-07-22 15:04 emiller Summary Cache the list of tables in the catalog/schema in the cache manager => Cache the lists of table names in each catalog/schema in the DDL reader
2025-07-22 15:04 emiller Description Updated View Revisions
2025-07-22 15:09 emiller Note Added: 0003263
2025-07-28 15:16 pbelov Status assigned => resolved
2025-07-28 15:16 pbelov Resolution open => fixed
2025-07-28 15:16 pbelov Fixed in Version => 3.16.5
2025-07-28 16:00 Changeset attached => SymmetricDS 3.16 9687f898
2025-08-07 15:49 pbelov Note Added: 0003297
2025-08-07 15:49 pbelov Status resolved => closed