I have a performance problem with the following query:
It takes between 2s 30s, and even in extreme cases 150s (we have about 100000 builds, the query returns about 1500 of them). I have 2 questions:
- are the results cached ? That would explain the differences in execution time
- is there more performant way to perform this query?