Questions for Confluence license has expired.

Please purchase a new license to continue using Questions for Confluence.

Trigger performance with "OR" statement.

 
1
0
-1

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.

    CommentAdd your comment...