Hello, we’re curious whether the sequence in which filters are applied affects query execution time from an optimization perspective. This applies to App data, Service data, and GraphQL queries as well.
1 Like
Hello!
The sequence should not have anything to say. The database analyses the query under the hood and reorders the filter to perform the query as efficiently as possible.
That said, the size of the filter has a big performance impact. The more properties that are evaluated, the longer it takes. Sorting also has a big performance impact.
3 Likes