Delay in JDBC Receive Adapter

[Former Member]

Hi Everyone.

I have an asynchronous scenario, RFC -> PI -> JDBC (Oracle DB)... This does an UPDATE in each message... When try to process 400 message the time of execution in the DB takes 2 minutes. For the client, this time is too long, but I've done everything and the time does not improve.

This is the message:

<?xml version="1.0" encoding="UTF-8"?>

<ns1:SQLString xmlns:ns1="urn:envioinventario:sap:seus">

<Statement>

<Inventario action="SQL_DML">

<access>UPDATE Inventario SET CAN = 65.0, CAN_CD = 876.9 WHERE C_EMP = &apos;JA&apos; AND BOD = &apos;72&apos; AND COD = &apos;T9876&apos;</access>

</Inventario>

</Statement>

</ns1:SQLString>

And this is the configuration of the cc:

Please, I need help, I don't know what else to do.

Thank you so much.

CRISTINA M. H.

[Harish · Accepted solution]

Hi Cristina,

the below blogs might be helpful to increase hte performance of scenario

regards,

Harish

[Former Member · Accepted solution]

Thank you!.... The links give some ideas.

Regarts,