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
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions