I’m currently working on an performance issue in a datacenter environment (Database on a remote host) where a lot of database queries cause a great delay while process a list of issues and their subtasks. (in total between 5k and 10k issues to process).
We are currently using the method, that I wanted to improve as it’s called for every Issue instead for a list of issues
issue.getSubTaskObjects()
Unfortunaly I was not able to find a Java API replacement that is capable to handle a list of issues instead of a single issue. Even the JQL is using a single query for each issue instead of a single query
parent in (PROJ-1, PROJ-2, PROJ-3)
Do someone know of a method that could be used to query the subtasks for a list of issues with a reduced amount of database queries?