How to improve the concurrent compute capability of workflow?

Avatar

Avatar

yueminspb

Avatar

yueminspb

yueminspb

14-01-2021

Hi Team, 

Could give us a guild line or a consult about this topic?

For we encountered a situation, that we are provided a interface for third-part data import.

For the reason of third-part development ability, they demanded us to provided a workflow to import its data. But it seems a high-frequency execution workflow, which has two activity node like below. The two node is js for data process and xtk.session.Write(myXML). But we found that, if the external signal invoked in 50 time/second, the workflow would be very slowly. Is there any method to improve the performance of workflow?

yueminspb_0-1610692373659.png 

yueminspb_1-1610692455834.png

yueminspb_2-1610692518255.png

 

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

DavidKangni

MVP

Avatar

DavidKangni

MVP

DavidKangni
MVP

15-01-2021

Hi,

 

ACC web services call have some limitation on TPS. It's not recommended to do bulk API update.

Work around can be:

  • the API write data to a file and a workflow pick up this file base on a frequency.
  • the API write data to a database and ACC connect to the DB to process the data
  • the API send requests to a middleware or microservices and this middleware will manage the queue /traffic to ACC

Thanks,

David

Answers (1)

Answers (1)

Avatar

Avatar

scott-simmer

Avatar

scott-simmer

scott-simmer

15-01-2021

You may consider an approach based not on external Signal / SOAP based workflow, but a JSSP with the connection handling and db write in one script.

 

The JSSP executions will multi-thread and scale to the number of available db connections.  You can then scale frontal servers/web modules as required.