AnsweredAssumed Answered

Poor performance of Boomi web services

Question asked by andrew.constantine309036 on Jun 23, 2017
Latest reply on Jun 30, 2017 by prashant.tiwari718253

Hi, 

A performance issue has arisen with the Boomi web services. Our legacy integration platform provides a response within 0.4 seconds where Boomi is taking 1.5 seconds. This is causing performance issues for the application that is calling the Boomi web service. 

This is a very simple process which queries a SQL Server Stored Procedure and then returns the data back to the requester. 
https://platform.boomi.com/#build;accountId=santos-RLX7UG;components=d71389ab-8ed3-4499-8430-fb1c1c6edcb9

 

I looked at implementing atom workers to handle the low latency web service calls, but it looks like this is unavailable to us as we use a local molecule installed on AWS? I can't find any documentation on how to setup a local molecule for best performance for web services, or if there is anything we can do to improve this situation. We have other web services which will be connecting more frequently, and we will also be adding a significant number of high volume ETLs to the molecule in future. Can someone provide advice on how we should setup Boomi to support low latency web services?  Any help would be appreciated.  We've checked disk i/o, memory and CPU, and all seem to be performing extremely well.

 

To test, I created the process with a 'No Data' start shape and added some test data into the process. Below is the process log, which shows a total process time of about 0.6 seconds (which would be fine), however it takes about 2 seconds to run when deployed as a web service and called.

 

 


Process Logs 
2017-06-23T06:36:25Z INFO 
initializing... Executing Process (WS) GLSS Nominations Query - Testing 
2017-06-23T06:36:25Z INFO 
Start NoData 
Executing Start Shape 
2017-06-23T06:36:25Z INFO 
Start NoData 
1 document(s) found for processing. 
2017-06-23T06:36:25Z INFO 
Start NoData 
Shape executed successfully in 41 ms. 
2017-06-23T06:36:25Z INFO 
Test Request Data Executing Message Shape with 1 document(s). 
2017-06-23T06:36:25Z INFO 
Test Request Data Shape executed successfully in 1 ms. 
2017-06-23T06:36:25Z INFO 
Get Nominations GLSS (SQL Server): database Connector; GLSS Nominations Get 
Executing Connector Shape with 1 document(s). 
2017-06-23T06:36:25Z INFO 
Get Nominations GLSS (SQL Server): database Connector; GLSS Nominations Get 
Shape executed successfully in 564 ms. 
2017-06-23T06:36:26Z INFO 
Map GLSS Nominations (DB to XML) 
Executing Map with 1 document(s). 
2017-06-23T06:36:26Z INFO 
Map GLSS Nominations (DB to XML) 
Shape executed successfully in 3 ms. 
2017-06-23T06:36:26Z INFO 
Return Documents Adding 1 document(s) to Return Documents return store. 
2017-06-23T06:36:26Z INFO 
Return Documents Shape executed successfully in 9 ms. 
2017-06-23T06:36:26Z INFO 
cleanup... Returning 1 document(s) in Return Documents return store. 
2017-06-23T06:36:26Z INFO 
cleanup... Process execution completed normally.

Outcomes