Performance....

[Former Member]

Hi All,

Can i use PACKAGE SIZE N in SELECT for better performance..as in ECD TEST n ECQ its not possible to check...as there no of records are very less...my problem is prog gets TIMEOUT...for extraction FOR ALL ENTRIES has been used...

Thanks

[Former Member]

hi,

package size is used only if the data extracted from the Db table is large and if u want to select in package of 100s, for example.

in your case:

Check if the source table which u r using in FOR ALL ENTIRES has duplicate reords. if so delete it.

it would be beter if can post your code here.

you should look into your select, i dont think package size will help you here.

regards,

madhu

[Former Member]

Hi Madhumita & Jeevitha,

I hav already checked the SELECT stmt....Its ok....

1) INITIAL status of the table checked

2) SORT stmt and DELETE ADJASCENT DUPLICATES stmt used on the table where FOR ALL ENTRIES clause exist

3) all the corresponding tables are also checked INITIAL or not

4) all the internal tables hav been refreshed..........

But still facing the TIMEOUT issue.....problem is ---1 dbtab size is more...How to get out of this issue....Any other soln....

Thanks.

[Former Member]

Hi,

i have given example for you.r u checking parent table is empty or not.if you didn't check that condition it will take more time to display second table details.

check once.

SELECT carrid connid

FROM spfli

INTO CORRESPONDING FIELDS OF TABLE entry_tab

WHERE cityfrom = p_city.

here check condition .it is mandatory.

if []entry_tab is initial.

SELECT carrid connid fldate

FROM sflight

INTO CORRESPONDING FIELDS OF TABLE sflight_tab

FOR ALL ENTRIES IN entry_tab

WHERE carrid = entry_tab-carrid AND

connid = entry_tab-connid.

endif.

[Former Member]

Hi Jeevitha,

INTO CORRESPONDING FIELDS...........decreases the performance....so whenever possible try to avoid that....you can defuine the fields in sequence as in internal table...

Thanks.

[Former Member]

Hi sagar,

just for reference i have given that example to show mandtory condition for all entries.

it not means write logic like that .

you told 1 dbtab is very high .

how many records you are retriving and based on what condition.check whether you are applying on non secondary index fields it will take nore time to execute.

[Former Member]

Hi Jeevitha,

Thanks for the quick response....

All the key fields / index used in the selection........so everything seems ok....but stll same problm....quarterly the size of the table is increasing by 10000...sizecatagory of dat table is 4 n expected records 100000 to 400000...tables are VBPA & VBFA....both having same.....others are just ok...Any soln

Thanks