topic Re: A017 performance Problem in Application Development and Automation Discussions

A017 performance Problem

Former Member — Thu, 05 Oct 2006 05:57:21 GMT

Hi all

I am facing performance problem, While selecting field 'DATAB' ( Validity start date of the condition record ) from Pooled table 'A017',I am getting timed out error ( slong ).IS there any efficient way to retrieve data.

Regards

Sreenivasa Reddy

Re: A017 performance Problem

Former Member — Thu, 05 Oct 2006 09:50:24 GMT

Hi sree

Can you show us how you have coded your select, how are you accessing this table?

Regards

Alfred

Re: A017 performance Problem

Former Member — Thu, 05 Oct 2006 10:04:14 GMT

Hi,

If possible try using maximum possible Key fields in your Select Query or goto Transaction ST05 and check your program SQL Trace which shows the delay for selecting values. Even if this is fine then you have to ask your Bassis guy to go extend the time Limit.

Thanks and Regards,

Prashanth

Re: A017 performance Problem

Former Member — Thu, 05 Oct 2006 12:06:50 GMT

Hi,

follow below condition to improve performance

1) Remove * from select

2) Select field in sequence as defined in database

3) Avoid unnecessary selects

i.e check for internal table not initial

4) Use all entries and sort table by key fields

5) Remove selects ferom loop and use binary search

6) Try to use secondary index when you don't have

full key.

7) Modify internal table use transporting option

😎 Avoid nested loop . Use read table and loop at itab

from sy-tabix statement.

9) free intrenal table memory wnen table is not

required for further processing.

10)

Follow below logic.

FORM SUB_SELECTION_AUFKTAB.

if not it_plant[] is initial.

it_plant1[] = it_plant[].

sort it_plant1 by werks.

delete adjacent duplicates from it_plant1 comparing werks

SELECT AUFNR KTEXT USER4 OBJNR INTO CORRESPONDING FIELDS OF TABLE

I_AUFKTAB

FROM AUFK

FOR ALL ENTRIES IN it_plant1

WHERE AUFNR IN S_AUFNR AND

KTEXT IN S_KTEXT AND

WERKS IN S_WERKS AND

AUART IN S_AUART AND

USER4 IN S_USER4 AND

werks eq it_plant1-werks.

free it_plant1.

Endif.

ENDFORM. "SUB_SELECTION_AUFKTAB

Regards

Amole