lix-community/nix-security-tracker
0
0
Fork 0
Code Issues 94 Pull requests 9 Projects Releases Packages Wiki Activity

Optimize query for suggestions list #288

New issue
Closed
opened 2024-10-28 09:29:44 +00:00 by fricklerhandwerk · 5 comments
fricklerhandwerk commented 2024-10-28 09:29:44 +00:00 (Migrated from github.com)
Copy link

The query on the suggestion view currently takes too long to demo

The query on the suggestion view currently takes too long to demo
erictapen commented 2024-11-11 12:05:04 +00:00 (Migrated from github.com)
Copy link

Fixed by https://github.com/Nix-Security-WG/nix-security-tracker/pull/292, right?

Fixed by https://github.com/Nix-Security-WG/nix-security-tracker/pull/292, right?
fricklerhandwerk commented 2024-11-11 12:11:22 +00:00 (Migrated from github.com)
Copy link

No:

All that remains is adding the right indexes to optimize the main queries. https://github.com/Nix-Security-WG/nix-security-tracker/pull/292#issue-2618045692

No: > All that remains is adding the right indexes to optimize the main queries. https://github.com/Nix-Security-WG/nix-security-tracker/pull/292#issue-2618045692
erictapen commented 2024-11-11 12:16:28 +00:00 (Migrated from github.com)
Copy link

Oops, sorry

Oops, sorry
RaitoBezarius commented 2024-11-20 18:23:35 +00:00 (Migrated from github.com)
Copy link

With the newest PR #378, the target is to cache anything that triggers additional queries, currently with 378, the cve_id triggers a needless fetch.

With the newest PR #378, the target is to cache anything that triggers additional queries, currently with 378, the cve_id triggers a needless fetch.
fricklerhandwerk commented 2024-11-28 16:28:54 +00:00 (Migrated from github.com)
Copy link

Closed by #378

Closed by #378
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
npins-auto-update
No results found.
Labels
Clear labels   
automation

   
backend

something the web server needs to provide the frontend with

  
bug

Something isn't working

  
contributor experience

   
data

something about quality or quantity of ingested data

  
deployment

   
documentation

Improvements or additions to documentation

  
duplicate

This issue or pull request already exists

  
good first issue

Good for newcomers

  
help wanted

Extra attention is needed

  
nice to have

Nice to have, but not necessary for the time being

  
notifications

   
package maintainer

user story for package maintainers

  
performance

   
skin

Anything related to the visual presentation

  
tech debt

Activities that reduce tech debt

  
user story

description or implementation of a workflow

No labels
automation
backend
bug
contributor experience
data
deployment
documentation
duplicate
good first issue
help wanted
nice to have
notifications
package maintainer
performance
skin
tech debt
user story
Milestone
Clear milestone
No items
No milestone
1 Quick triaging
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: lix-community/nix-security-tracker#288
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?