EIM performance decreased when using DEFAULT COLUMN in ifb file
(Doc ID 546622.1)
Last updated on MAY 01, 2018
Applies to:Siebel Enterprise Integration Manager - Version 188.8.131.52 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 184.108.40.206  DEU Fin Svcs
Database: IBM DB2 8.1 FixPack 3
Application Server OS: Microsoft Windows 2000 Advanced Server SP 3
Database Server OS: Microsoft Windows 2000 Advanced Server SP 3
This document was previously published as Siebel SR 38-1475736921.
***Checked for relevance on 06-Feb-2013***
""Checked for relevance on 13-May-2016""
We plan to import ~ 300000 activities using EIM. We are now trying to speed up the process. We found that for each single fixed column, EIM will execute one update - statement on the EIM-table (see attached log file). Since we have 25 fixed columns (see attached ifb file), EIM executes 25 update statements with the same "where" - clause. Each takes around 3 minutes.
Why doesn't EIM just execute one update statement that updates all 25 columns instead of updating the columns one by one ?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document