topic sql performnace problem.. in Application Development and Automation Discussions

sql performnace problem..

Former Member — Fri, 27 Jul 2007 05:53:57 GMT

Hi all,

in my code..

SELECT SINGLE FIELDNAME

TABNAME

CHECKTABLE

ROLLNAME

ENTITYTAB

DOMNAME

DDTEXT

INTO (WDD03M-FIELDNAME

,WDD03M-TABNAME

,WDD03M-CHECKTABLE

,WDD03M-ROLLNAME

,WDD03M-ENTITYTAB

,WDD03M-DOMNAME

,WDD03M-DDTEXT

)

FROM DD03M

WHERE TABNAME LIKE 'AUTH%'

AND DDLANGUAGE = SY-LANGU

AND FIELDNAME = FLD

AND FLDSTAT = 'A'

AND ROLLSTAT = 'A'

AND DOMSTAT = 'A'

AND TEXTSTAT = 'A'.

here im getting time out dump..

please help me how to make this perfomance gud..

here im taking data from view..

wht exactly wrong with this code i mean as performance wise..whts wrong with this code..

Re: sql performnace problem..

Former Member — Fri, 27 Jul 2007 05:59:53 GMT

You are using SELECT SINGLE and in where condition you are using TABNAME LIKE AUTH%, there will be some thousands of records starting with AUTH letters

so give some fixed name like AUTHA or something which you want

it will work.

So it is taking time for this.

Reward points for useful Answers

Regards

Anji

Re: sql performnace problem..

Former Member — Fri, 27 Jul 2007 06:01:13 GMT

tables dd03m.

SELECT SINGLE FIELDNAME

TABNAME

CHECKTABLE

ROLLNAME

ENTITYTAB

DOMNAME

DDTEXT

INTO (DD03M-FIELDNAME,DD03M-TABNAME,DD03M-CHECKTABLE,DD03M-ROLLNAME,

DD03M-ENTITYTAB,DD03M-DOMNAME,DD03M-DDTEXT)

FROM DD03M

WHERE TABNAME LIKE 'AUTH%'

AND DDLANGUAGE = SY-LANGU

AND FIELDNAME = 'FLD'

AND FLDSTAT = 'A'

AND ROLLSTAT = 'A'

AND DOMSTAT = 'A'

AND TEXTSTAT = 'A'.

Copy paste the code, the errors are rectified.

Regards,

Pavan.

Re: sql performnace problem..

Former Member — Fri, 27 Jul 2007 06:07:17 GMT

HI Anji Reddy.

thn first i can concatnate this string into one name n thne i can use like this?

here in this case .

CONCATNATE 'AUTH%' INTO AUTH.

N THEN IN WHERE CLUASE GIVE THIS AUTH NAME LIKE THIS ?

Re: sql performnace problem..

kesavadas_thekkillath — Fri, 27 Jul 2007 06:08:49 GMT

try to split ...i guess it may work ...

ranges:wk_fld for <table-field>

wk_fld-option = 'EQ'

wk_fld-sign = 'I'.

loop at it.

move fld to wk_fld-low.append wk_fld.clear wk_fld.

endloop.

then select the records from dd03m

select FIELDNAME TABNAME CHECKTABLE ROLLNAME ENTITYTAB DOMNAME

DDTEXT appending table itab from dd03m

where AND FLDSTAT = 'A'

AND ROLLSTAT = 'A'

AND DOMSTAT = 'A'

AND TEXTSTAT = 'A'

TABNAME LIKE 'AUTH%'

and fieldname in wk_fld.

hope this may work