topic Re: performance issue in Application Development and Automation Discussions

performance issue

Former Member — Mon, 06 Aug 2007 17:42:53 GMT

My code below is taking too much time around 13,369,415

I need to improve the performance of the code. any ideas!!!

  SELECT SINGLE aufnr
        FROM mseg
        INTO v_aufnr
        WHERE charg IN charg
        AND   bwart = v_move.

rodrigo_paisante3 — Mon, 06 Aug 2007 18:00:45 GMT

Hi.

The use of IN kill performance. Try to select without IN.

Regards.

Former Member — Mon, 06 Aug 2007 18:08:34 GMT

I tried without

IN

and its the same performace. It has to do with

MSEG

table, I think the table has a lot of data and too many fields.

Former Member — Mon, 06 Aug 2007 18:47:56 GMT

Use AUFM table