2LIS_02_SCL perfomance improvement

[Former Member]

Experts,

In our current system, we see 2LIS_02_SCL extractor is taking long time to extract records in daily delta and we intent to optimize the run time of the extractor. At present for processing ~ 6500 records it is taking good amount of 42 mints. Ofcourse in CMOD we have many custom logic added which is possibly the reason for slowness.

We have planned to replace certain codes and try to optimize the logic :

1) All select single within loop will be replaced by internal table and read table logic- any idea how much this will optimize the run time ?

2) Can field symbol be useful here. If we use it will that create any data load problems and what is the run time optimization we can get?

Any other suggestion are welcome.

[matt · Accepted solution]

In the ABAP space there are articles and discussions about optimising ABAP code. There is no "one size fits all" answer. Doing what you suggest may make things better, but it's not really possible to say for sure without seeing the actual code.

Point 1 will probably help. Do use INNER JOINs rather than FOR ALL ENTRIES. There is a widely believed myth that the latter is better than the former. In most cases this is untrue.

Point 2. It depends what you're doing with them.

Run an SQL trace on the process, and try to identify expensive table accesses. Sometimes adding an appropriate index to a table works miracles.

As far as determining the benefits of making changes - without running the process several times it's not really possible to tell.

[former_member182343]

Dear Krish,

Can u plz come here with Amended CMOD logic.

Although your views are correct regarding code, lets check once.

Is the load daily basis or weekly?

Regards, Vijay