Skip to content

[Bug] using quick-filter "shared with my org" takes arround 90 seconds #1979

Closed
@crackytsi

Description

@crackytsi

Request Type

Bug

Work Environment

Question Answer
OS version (server) Debian
OS version (client) 10
Virtualized Env. False
Dedicated RAM 64 GB
vCPU 8
TheHive version / git hash 4.1.4
Package Type DEB
Database Cassandra
Index type Lucene
Attachments storage Local

Problem Description

Using Quick-filter "shared with my org" takes very log to load and all 8 CPUs are high CPU usage.
Some details:
/api/v1/query?name=cases.count
image

{"query":[{"_name":"listCase"},{"_name":"filter","_not":{"_like":{"_field":"owningOrganisation","_value":"myOrg2"}}},{"_name":"limitedCount"}]}

/api/v1/query?name=cases

image
{"query":[{"_name":"listCase"},{"_name":"filter","_not":{"_like":{"_field":"owningOrganisation","_value":"myOrg2"}}},{"_name":"sort","_fields":[{"flag":"desc"},{"startDate":"desc"}]},{"_name":"page","from":0,"to":15,"extraData":["observableStats","taskStats","procedureCount","isOwner","shareCount","permissions","actionRequired"]}]}

Metadata

Metadata

Assignees

Labels

TheHive4TheHive4 related issuesbug

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions