topic Re: need help in performance in Application Development and Automation Discussions

need help in performance

Former Member — Mon, 10 Dec 2007 10:18:40 GMT

hallow

i doing this select and it take more then 10 minutes and i don't now way because

object_key have just 60 entries ?

how i can slve this problem?

Regards


  SELECT * FROM covp APPENDING TABLE *covp
          FOR ALL ENTRIES IN object_key
           WHERE kokrs EQ '1000'
           AND   objnr EQ object_key-objnr
           AND   budat IN so_budat
           AND   stflg EQ space .

Re: need help in performance

Former Member — Mon, 10 Dec 2007 10:28:38 GMT

Insted of this try this.

SELECT * FROM covp

INTO TABLE temp_covp

FOR ALL ENTRIES IN object_key

WHERE kokrs EQ '1000'

AND objnr EQ object_key-objnr

AND budat IN so_budat

AND stflg EQ space .

loop at temp_covp.

append temp_covp to covp.

endloop.

So that we can reduce the burdan on Select query.

All the best to you.

- Mohan