Transaction executing slow and database undo log increasing soon.
I developed a transaction which query database many times in a repeater loop and finally generate a SAP MII XML Output Document which I want to display in a html hyper link in MII Navigation. (Using XacuteQuery and iGrid)
I found that
1. if I execute in SAP MII Workbench, the transaction executing very slow, and also the database undo log in D:\oracle\TMI\sapdata2\undo_1\UNDO.DATA1 increasing soon.
2. If I use MII Schedule Edit to run the transaction, it executing fast.
Does any one know why?
Is there any setting can make it executing fast in a MII Workbench?