Closed
Description
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
{"query":[{"_name":"listCase"},{"_name":"filter","_not":{"_like":{"_field":"owningOrganisation","_value":"myOrg2"}}},{"_name":"limitedCount"}]}
/api/v1/query?name=cases
{"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"]}]}