Environment (Required on creation):

Using the Docker Container on a Windows 11 WSL 2:
https://hub.docker.com/r/camunda/camunda-bpm-platform

docker run -d --name camunda-latest -p 8443:8443 camunda/camunda-bpm-platform:run-latest ./camunda.sh --production

PAUSE

Description (Required on creation; please attach any relevant screenshots, stacktraces, log files, etc. to the ticket):

I have completed 4 Process-Instances. I'm trying to implement a backend Filter but after I try to create a request to the endpoint, im going into a timeout error. But this only happens if:

• I got more than 4 unique properties
• on 'process-instance/count'

Steps to reproduce (Required on creation):

1. docker run -d --name camunda-latest -p 8443:8443 camunda/camunda-bpm-platform:run-latest ./camunda.sh --production
2. Create a POST-Request per e.q Postman
   1. POST: https://localhost:8443/engine-rest/history/process-instance/count
   2. Body: 

      {
          "processDefinitionKey": "process_spezialAnlage",
          "completed": "true",
          "variableValuesIgnoreCase": true,
          "orQueries": [
              {
                  "variables": [
                      {
                          "name": "Prop1",
                          "operator": "like",
                          "value": "%123%"
                      },
                      {
                          "name": "Prop2",
                          "operator": "like",
                          "value": "%123%"
                      },
                      {
                          "name": "Prop3",
                          "operator": "like",
                          "value": "%123%"
                      },
                      {
                          "name": "Prop4",
                          "operator": "like",
                          "value": "%123%"
                      },
                      {
                          "name": "Prop5",
                          "operator": "like",
                          "value": "%123%"
                      }
                  ]
              }
          ]
      }

Observed Behavior (Required on creation):

Running into a timeout or loaded after a couple of minutes.

Expected behavior (Required on creation):

Getting my Data.

Root Cause (Required on prioritization):

Solution Ideas (Optional):

Indexing database?

Better database (more performant) queries? 

Hints (optional):

This queries are working on other endpoints perfectly and without a timeout (or a long request time). It looks like this specific endpoint is requesting very long. If I use another endpoint "https://localhost:8443/engine-rest/history/task/count" with exact the same query (but changing variables to processVariables). It works under 10ms and I got my completed tasks!