Poor performing creation of Issues call JIRA API

MarkoRocko_4zsio7

When I call the JIRA API in groovy code triggered by choosing a menu item, the code creates about 20 Issues then within each issue it creates another 5 Issues.

The process takes a LONG TIME! A little over a minute.  So, two questions?

(1) Is it likely, the reason for slow performance on the back end is it will process 100= 5 x 20 database calls?  If not, whats your best guess?

(2) Is there a way to do this same call more efficiently and complete in seconds rather than minutes?  
Perhaps, a way to batch requests?  Skip the JIRA API and write to the DB directly?  What can be done?

Nic Brough -Adaptavist-

To write to a Jira database with SQL, you have to

• know exactly what you are doing (and almost everyone fails that test)
• Have Jira shut down, and usually run a full re-index after restarting it

So, no, you don't want to do that.

The speed is probably simply a function of the complexity of what you're trying to do.  The server process is going as fast as it can without compromising other users.