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"]}]}