Skip to content

[LabKey CI] Eliminate DbCache use #5518

@labkey-adam

Description

@labkey-adam

DbCache uses a very inefficient invalidation mechanism (the entire cache is cleared on insert, update, or delete of any row in any container). It's time to migrate uses to a more standard and efficient caching pattern, and eliminate this class.

  • Migrate experiment runs cache DbCache -> DatabaseCache
  • Migrate participant cache DbCache -> DatabaseCache
  • Migrate StudyCache/QueryHelper DbCache -> DatabaseCache
  • Add validation checking (old vs. new return values) and logging
  • Fix failing tests and flagged validation problems
  • Code review - @labkey-jeckels
  • Merge with validation in place
  • Fix tests (participant cache invalidation, delete specimen tables, bad insert button)
  • Code review 2
  • Merge test fixes
  • Remove validation code and DbCache
  • Code review 3
  • Merge final PR

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions