JBoss servers' CPU usage reaching >300% when Appian API is triggered by MuleSoft

Apoorv Gangwar

A Score Level 2

over 5 years ago

When the integration layer, MuleSoft triggers Appian's "PUT" service Web API sending around 100MB of data, the 2 JBoss servers CPU usage on the Appian side reaches >300%. Thereby causing performance issues and the MuleSoft gets 401 error, as the Web API is taking long time to process the data.

Has anyone faced this issue earlier and found a working solution to it? Any suggestions on how to resolve this JBoss CPU over utilization issue.

Discussion posts and replies are publicly visible

Parents

0 aloks0189
Certified Lead Developer
over 5 years ago

Hi Apoorv Gangwar what do you mean by 100 mb of data? Is that a file such as excel , CSV contains plenty of rows or a file like a document.

Because if it's the excel or CSV which contains the data retrieved from db, then I believe you should process the in batch size instead of processing the whole amount of data.

But if it's a binary data, then may I know, how are you transferring the document to the client?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Apoorv Gangwar
A Score Level 2
over 5 years ago in reply to aloks0189

100 MB of data is in JSON format, which mulesoft sends through Web API. Then we save this data into db.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aloks0189
Certified Lead Developer
over 5 years ago in reply to Apoorv Gangwar

Are there any possibility, where we can ask the mulesoft to send the data in batch. Because holding so huge amount of data in memory and performing your operation over this is never recommended as this will cause performance issues.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 aloks0189
Certified Lead Developer
over 5 years ago in reply to Apoorv Gangwar

Are there any possibility, where we can ask the mulesoft to send the data in batch. Because holding so huge amount of data in memory and performing your operation over this is never recommended as this will cause performance issues.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Justin Watts
Certified Lead Developer
over 5 years ago in reply to aloks0189

Agree with Alok. Mulesoft is a flexible middleware. I expect a workflow could be developed that would allow for batched calls to Appian.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Apoorv Gangwar
A Score Level 2
over 5 years ago in reply to Justin Watts

The problem is this amount of data will flow every 5 minutes from mulesoft.
I had a discussion with Appian support and according to them, doing huge data transactions through web API not recommended. They suggested that mulesoft should directly connect to Appian DB and send the data.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel