topic Re: Performance issue - Select statement in Application Development and Automation Discussions

Performance issue - Select statement

Former Member — Mon, 16 Apr 2007 13:57:46 GMT

Hi I am having the 10 lack records in the KONP table . If i am trying to see all the records in SE11 , it is giving the short dump TSV_TNEW_PAGE_ALLOC_FAILED . I know this is because of less memory in the Server . Is there any other way to get the data ? How to optimise the below SELECT statement if i have large data in the table .

i_condn_data - is having 8 lack records .

SELECT knumh kznep valtg valdt zterm

FROM konp

INTO TABLE i_condn_data_b

FOR ALL ENTRIES IN i_condn_data

WHERE knumh = i_condn_data-knumh

AND kschl = p_kschl.

Please suggest .

Re: Performance issue - Select statement

Former Member — Mon, 16 Apr 2007 14:02:05 GMT

Hi,

Try to use all Primary keys from KONP in the WHERE condition of the Select statment. that will be only solution

Regards

Sudheer

Re: Performance issue - Select statement

Former Member — Mon, 16 Apr 2007 14:03:31 GMT

Hi,

You can make use of the PACKAGE SIZE addition for the SELECT statements.

This will read data from table in sets rather than the whole table.

Regards,

Sumant.

Re: Performance issue - Select statement

Former Member — Mon, 16 Apr 2007 14:11:11 GMT

Hi..

if u want all the data..

divide the table <b>i_condn_data into 4 internal tables with 2 lakh records</b>.

write select query four times with these 4 itabs..which will avoid short dump..

Re: Performance issue - Select statement

Former Member — Mon, 16 Apr 2007 14:14:34 GMT

hi,

As said above ... Include all the primary key fields in your select statement in where condition and try to divide the data in to multiple internal tables ...

regards,

Santosh

Re: Performance issue - Select statement

Former Member — Mon, 16 Apr 2007 14:19:33 GMT

Hi,

try to use "UP TO n ROWS" to control the quantity of selected data in each Loop step.

Something like this:

sort itab by itab-knumh.

flag = 'X'.

while flag = 'X'.

SELECT knumh kznep valtg valdt zterm

FROM konp

INTO TABLE i_condn_data_b UP TO one_million ROWS

WHERE knumh > new_value_for_selection

AND kschl = p_kschl.

describe table i_condn_data_b lines i.

read table i_condn_data_b index i.

new_value_for_selection = i_condn_data_b-knumh.

*....your logic for table i_condn_data_b

if one_million > i.

clear flag.

endif.

endwhile.

Regards

Re: Performance issue - Select statement

Former Member — Mon, 16 Apr 2007 14:21:32 GMT

chk for duplicate entries in i_condn_data comparing knumh.

try to split your select or use package size option in ur select.

regards,

madhu