qwc-open/asiakirjat
Watch
1
0
Fork
You've already forked asiakirjat
 0
Code Issues 1 Pull requests Projects Releases 34 Packages 1 Wiki Activity Actions

Search: cache latest version tags to avoid per-query DB lookups #19

New issue
Closed
opened 2026-02-02 22:57:20 +01:00 by qwc · 0 comments
qwc commented 2026-02-02 22:57:20 +01:00
Owner
Copy link

The "latest version only" filter in getLatestVersionTags() queries all projects and their versions from the database on every search request. This should be cached (e.g. in-memory with a short TTL or invalidated on upload/delete) to avoid unnecessary DB load.

The "latest version only" filter in `getLatestVersionTags()` queries all projects and their versions from the database on every search request. This should be cached (e.g. in-memory with a short TTL or invalidated on upload/delete) to avoid unnecessary DB load.
qwc closed this issue 2026-02-03 11:26:00 +01:00
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
fix/private-project-access
v0.8.2
v0.8.1
v0.8.0
v0.8.0-rc3
v0.8.0-rc2
v0.8.0-rc1
v0.7.0
v0.7.0-rc2
v0.7.0-rc1
v0.6.1
v0.6.0
v0.5.1
v0.5.0
v0.5.0-beta-pdf-2
v0.5.0-beta-searchable-pdf
v0.5.0-beta-pdf
v0.5.0-beta+pdfsupport
v0.4.0-test1
v0.4.0
v0.3.9
v0.3.8
v0.3.7
v0.3.6
v0.3.5
v0.3.4
v0.3.3
v0.3.2
v0.3.1
v0.3.0
v0.2.1
v0.2.0
v0.1.3
v0.1.2
v0.1.1
v0.1.0
Labels
Clear labels   
Compat/Breaking
Breaking change that won't be backward compatible

  
Kind/Bug
Something is not working

  
Kind/Documentation
Documentation changes

  
Kind/Enhancement
Improve existing functionality

  
Kind/Feature
New functionality

  
Kind/Security
This is security issue

  
Kind/Testing
Issue or pull request related to testing

  
Priority
Critical
 The priority is critical

  
Priority
High
 The priority is high

  
Priority
Low
 The priority is low

  
Priority
Medium
 The priority is medium

  
Reviewed
Confirmed
 Issue has been confirmed

  
Reviewed
Duplicate
 This issue or pull request already exists

  
Reviewed
Invalid
 Invalid issue

  
Reviewed
Won't Fix
 This issue won't be fixed

  
Status
Abandoned
 Somebody has started to work on this but abandoned work

  
Status
Blocked
 Something is blocking this issue or pull request

  
Status
Need More Info
 Feedback is required to reproduce issue or to continue work

No labels
Compat/Breaking
Kind/Bug
Kind/Documentation
Kind/Enhancement
Kind/Feature
Kind/Security
Kind/Testing
Priority
Critical
Priority
High
Priority
Low
Priority
Medium
Reviewed
Confirmed
Reviewed
Duplicate
Reviewed
Invalid
Reviewed
Won't Fix
Status
Abandoned
Status
Blocked
Status
Need More Info
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set

Reference
qwc-open/asiakirjat#19
No description provided.