JDBC interface: taking too much time to update

[former_member440449]

Hi guys,

We are facing some new issues for an existing interface. This is an asynch JDBC receiver interface, where ECC sends some information to update only 4 fields (using also 4 keys) into an informix database.

This interface has gone live for a year without any issues, but this week it is taking too much time to finish the process.

In today's case, it takes more than 90 minutes to do less than 18000 updates. It finish successful but we can't wait that time for a simple process.

Also, we tried to do an update of these 18000 records in the DB itself and it took seconds.

I didn't ask BASIS guys yet if they change any PI parameter of something like that. Also I discard any network issues as everything is fine.

My question is: why could the JDBC receiver adapter take all that time to finish the process? Is there anything that I can do to make it faster?

Thanks!

[Former Member]

are you doing INSERT_UPDATE? 180,000 records in single message?

[former_member440449]

18,000 records, not 180,000 and yes, it is an INSERT_UPDATE.

[Former Member]

you can try increase the maximum concurrency in receiver channel.