topic Re: Performance issue .. very long time in Application Development and Automation Discussions

Performance issue .. very long time

Former Member — Fri, 01 Sep 2006 06:29:16 GMT

Hi,

This select statement is bee running since more than a day.. please help.

select matnr

BDTER

BDMNG

ebeln

ebelp

from resb

into table i_resb

for all entries in i_ekpo

where ebeln = i_ekpo-ebeln

and ebelp = i_ekpo-ebelp.

i_ekpo has all subcon orders (pstyp = 3)

Help to correct the stmnt.

Re: Performance issue .. very long time

Former Member — Fri, 01 Sep 2006 06:30:41 GMT

this code is looking ok...i thinkproblem is anywhere else....

<b>if not i_ekpo[] is initial</b>. 
select matnr
BDTER
BDMNG
ebeln
ebelp
from resb
into table i_resb
for all entries in i_ekpo
where ebeln = i_ekpo-ebeln
and ebelp = i_ekpo-ebelp.
endif.

Re: Performance issue .. very long time

Former Member — Fri, 01 Sep 2006 06:33:18 GMT

IF i_ekpo[] IS NOT INITIAL.

select matnr

BDTER

BDMNG

ebeln

ebelp

from resb

into table i_resb

for all entries in i_ekpo

where ebeln = i_ekpo-ebeln

and ebelp = i_ekpo-ebelp.

ENDIF.

Re: Performance issue .. very long time

Former Member — Fri, 01 Sep 2006 06:33:32 GMT

Hellom

Before going the for all entires

are you doing all the checks..

IF not i_ekpo[] is initial.

sort i_ekpo.

Delete adjacent duplicates from i_ekpo comparing <field name>.

select matnr

BDTER

BDMNG

ebeln

ebelp

from resb

into table i_resb

for all entries in i_ekpo

where ebeln = i_ekpo-ebeln

and ebelp = i_ekpo-ebelp.

Endif.

Create and index for ebelp in resb.

Thanks,

Krishnakumar

Message was edited by: Krishnakumar

Re: Performance issue .. very long time

Former Member — Fri, 01 Sep 2006 06:33:46 GMT

I have included that and also i_ekpo has values

Re: Performance issue .. very long time

Former Member — Fri, 01 Sep 2006 06:36:55 GMT

how to create an index?

Re: Performance issue .. very long time

Former Member — Fri, 01 Sep 2006 06:37:55 GMT

Hi...Kantheri..

Try to use primary keys (RSNUM,RSPOS,RSART) in your SELECT query and then run it.

Thank You

Re: Performance issue .. very long time

Former Member — Fri, 01 Sep 2006 06:39:46 GMT

Don't use for all entries. For tables like RESB:

sort i_ekpo by ebeln ebelp.

delete adjacent duplicates from i_ekpo comparing ebeln ebelp.

loop at i_ekpo.

your select statement
without "for all entries" clause

endloop.

Re: Performance issue .. very long time

Former Member — Fri, 01 Sep 2006 06:42:17 GMT

Hi,

Use all the primary keys of RESB in your where condition, further how many entries are there in ur internal table i_ekpo.

If you can restrict the entries in i_ekpo, if you can narrow down on ur selection criteria for values from EKPO --- it should help you a lot.

Reward if helpful.

Regards

Re: Performance issue .. very long time

Former Member — Fri, 01 Sep 2006 06:53:32 GMT

Subhash, how do i get those fields.

RSDB is empty.

Re: Performance issue .. very long time

Former Member — Fri, 01 Sep 2006 06:55:11 GMT

Hi,

Did u try my suggestion...

Regards

Re: Performance issue .. very long time

Former Member — Fri, 01 Sep 2006 07:04:55 GMT

Hi Zapper,

How do i get all the primary keys.

Ekpo doesnot have it.

and RSDB is not updated for subcon po's.

Please help

Re: Performance issue .. very long time

Former Member — Fri, 01 Sep 2006 07:12:07 GMT

Thanks for all your help.

Could anyone help me create an index in RESB for ebelen and ebelp. The steps involved.

I hope this would help.

Re: Performance issue .. very long time

Former Member — Fri, 01 Sep 2006 07:14:12 GMT

first get RSNUM of PO from EKET then go for RESB.

Regards

Prabhu

Re: Performance issue .. very long time

Former Member — Mon, 13 Nov 2006 12:30:16 GMT

Hallo, this is how to create an index:

Transaction SE11.

select database table RESB --> show it.

goto indizes (Strg + F5) and create a new one with the name you want (like Z01)

type in short description and the needed fields (ebelen and ebelp) and select "non-unique-index" and "index on all database systems" if this is right for you.

then aktivate the index.

afterwards goto SE14 and select the Table RESB in edit mode.

goto indizes and select the created index (Z01)

then choose "create database index" and perform it in background modus (!?!) to avoid short dumps.

after it is created on the database you can check the database in SE14 by choosing "check" --> if everything is ok --> then your finished.

i how this helps.

sorry for my english but translating the technical expressions is somehow hard...

bye from lake constance, germany

m.lindenmayer