Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Slow entities list queries with status templates #6516

Closed
SouadHadjiat opened this issue Mar 29, 2024 · 0 comments
Closed

Slow entities list queries with status templates #6516

SouadHadjiat opened this issue Mar 29, 2024 · 0 comments
Assignees
@richard-julien
Labels
bug use for describing something not working as expected solved use to identify issue that has been solved (must be linked to the solving PR)
Milestone
Release 6.0.9

Comments

@SouadHadjiat
Copy link
Member

Description

We've observed slow queries (reports listing) related to querying status with templates for each report, not using cache or batch loading for templates, which can affect performance of these queries.

Environment

  1. OS (where OpenCTI server runs): local dev server
  2. OpenCTI version: latest
  3. OpenCTI client: frontend
  4. Other environment details:
@SouadHadjiat SouadHadjiat added bug use for describing something not working as expected needs triage use to identify issue needing triage from Filigran Product team labels Mar 29, 2024
@SouadHadjiat SouadHadjiat self-assigned this Mar 29, 2024
@SouadHadjiat SouadHadjiat removed the needs triage use to identify issue needing triage from Filigran Product team label Mar 29, 2024
@SamuelHassine SamuelHassine added this to the Release 6.0.9 milestone Mar 30, 2024
richard-julien added a commit that referenced this issue Mar 30, 2024
@richard-julien
[backend] Improve template loading if available in cache (#6516)
29d8f07
@richard-julien richard-julien mentioned this issue Mar 30, 2024
Merged
SamuelHassine pushed a commit that referenced this issue Apr 2, 2024
@richard-julien
[backend] Improve template loading if available in cache (#6516)
1dfedab
@SamuelHassine SamuelHassine added the solved use to identify issue that has been solved (must be linked to the solving PR) label Apr 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@richard-julien richard-julien

Labels
bug use for describing something not working as expected solved use to identify issue that has been solved (must be linked to the solving PR)
Projects
None yet
Milestone
Release 6.0.9
Development

No branches or pull requests
3 participants
@richard-julien @SouadHadjiat @SamuelHassine