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 list entities graphQL queries with refs loading #6635

Closed
SouadHadjiat opened this issue Apr 9, 2024 · 0 comments · Fixed by #6636
Closed

Slow list entities graphQL queries with refs loading #6635

SouadHadjiat opened this issue Apr 9, 2024 · 0 comments · Fixed by #6636
Assignees
@SouadHadjiat
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.10

Comments

@SouadHadjiat
Copy link
Member

Description

I've observed locally slow loading (>30 seconds) when querying entities list with markings, labels, authors. There seem to be an issue with batch loading (loadThroughDenormalized)

Environment

  1. OS (where OpenCTI server runs): local dev server
  2. OpenCTI version: 6.0.9
  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 Apr 9, 2024
@SouadHadjiat SouadHadjiat self-assigned this Apr 9, 2024
@SouadHadjiat SouadHadjiat removed the needs triage use to identify issue needing triage from Filigran Product team label Apr 9, 2024
SouadHadjiat added a commit that referenced this issue Apr 9, 2024
@SouadHadjiat
[backend] fix rels batch loading (#6635)
1568d61
@SouadHadjiat SouadHadjiat mentioned this issue Apr 9, 2024
Merged
5 tasks
@SouadHadjiat SouadHadjiat linked a pull request Apr 9, 2024 that will close this issue
[backend] fix rels batch loading (#6635) #6636
Merged
5 tasks
SouadHadjiat added a commit that referenced this issue Apr 10, 2024
@SouadHadjiat
[backend/frontend] Fix rels batch loading & perf (#6635)
9bb7b22
@SamuelHassine SamuelHassine added the solved use to identify issue that has been solved (must be linked to the solving PR) label Apr 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@SouadHadjiat SouadHadjiat

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.10
Development

Successfully merging a pull request may close this issue.

[backend] fix rels batch loading (#6635) OpenCTI-Platform/opencti
2 participants
@SouadHadjiat @SamuelHassine