Trigger performance with "OR" statement

Use Case
, , , ,
1

Originally asked by KyoungMan Kim on 11 August 2021 (original question)

Hello All,

We are going to optimize our JQL trigger to improve JIRA performance.

As I know, Exalate can set multiple JQL triggers on a connection.
Then I wonder which of the following configuration is better.

  • Purpose : Synchronize Bug, Task and Sub-task of 2 projects.
    • Case A : Config trigger as one JQL
      - project in (AAAA, BBBB) AND (issuetype in (Bug, Task) OR issuefunction in subtasksOf(“project in (AAAA, BBBB) AND issuetype in (Bug, Task) AND issue in under_sync_by_connection(‘CONNECTION_NAME’)”))
      • Case B : Config triggers as two or more JQLs
        • project in (AAAA, BBBB) AND issuetype in (Bug, Task)
        • project in (AAAA, BBBB) AND issuefunction in subtasksOf(“project in (AAAA, BBBB) AND issuetype in (Bug, Task) AND issue in under_sync_by_connection(‘CONNECTION_NAME’)”))

Thanks.