Skip to Content

JDBC interface: taking too much time to update

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?


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 28, 2015 at 10:34 PM

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

    Add comment
    10|10000 characters needed characters exceeded