JDBC Insert takes more time

[Former Member]

Hi,

We are using BPM to insert a JDBC table. The send step takes 5 mins to insert 10k records. We have used similar design in other processes but does not take much time,.

What would be the issue?

Regards

Krish

[Former Member · Accepted solution]

Krish,

We are using BPM to insert a JDBC table.  The send step takes 5 mins to insert 10k records.

I think that indexing has not been done. Verify that. if not, do the indexing which will reduce the processing time significantly.

Regards,

Neetesh