Do we have any details on what FirstInsertWithCommit function does?
If someone can provide details on what FirstInsertWithCommit peoplecode function does? One example is as below
FirstInsertWithCommit("INSERT INTO PS_EOAW_IDS (EOAWCOUNTERNAME, EOAWCOUNTER) VALUES (:1, :2)", "EOAW_HIS_COMM", 1); Which is used in EOAW_COMMENT AE process. It's mostly known issue that EOAW_COMMENT process running long in 9.2. During our internal analysis we have found 90% time (for example, in our recent run it took around 9 hrs but out of which only 10 min of time spent in SQLs. Remaining time spent in the application side) spent in the application side. Not sure what's causing this slowness in the application side. So part of it want to understand what this function does. If someone can explain would be helpful