25.6 EIM_ACCNT S_ORG_EXT Row by Row Processing Instead Of Set Based Processing

Hi All,

A customer of ours was running a once a year EIM process to load accounts into s_org_ext. They complained that the processing time was 4x longer than normal. We looked and noticed for S_ORG_EXT the inserts into S_ORG_EXT were being done row by row (RBR) with bind variables instead of the normal set based processing where the insert is driven by a select from the EIM table. Our batch size is 10K so instead of one insert that inserts 10K records we we doing 10k inserts instead of just the one.

We know if transaction logging is enabled for Siebel remote or pre IP 17 local databases this is the expected behavior. The only other thing that can cause this behavior is if your specify and EIM IFB option to force transaction logging. Neither of these conditions were true so we we really baffled by what could be causing the behavior.