topic Re: Sort statement performance in Application Development and Automation Discussions

Sort statement performance

sudha_naik — Tue, 11 Dec 2007 09:10:23 GMT

Hello

This sort statement is taking too much of time.

SORT MAKT_KEYTAB BY MATNR SPRAS.

Is there any option using which we can optimise this ?

Thanks

Sudha

Re: Sort statement performance

Former Member — Tue, 11 Dec 2007 09:15:53 GMT

Hi,

send me your internal table strucutre.

Re: Sort statement performance

Former Member — Tue, 11 Dec 2007 09:16:36 GMT

How did you define the table? If possible try sorted table.

Re: Sort statement performance

sudha_naik — Tue, 11 Dec 2007 09:18:50 GMT

DATA: BEGIN OF MAKT_KEYTAB OCCURS 0,

MANDT LIKE SYST-MANDT,

MATNR LIKE MAKT-MATNR,

SPRAS LIKE MAKT-SPRAS,

END OF MAKT_KEYTAB.

Re: Sort statement performance

Former Member — Tue, 11 Dec 2007 09:23:10 GMT

MAKE IT AS binary SEARCH

SORT MAKT_KEYTAB BY MATNR SPRAS binary serach .

The binary search algorithm helps faster search of a value in an internal table. It is advisable to sort the internal table before doing a binary search. Binary search repeatedly divides the search interval in half. If the value to be searched is less than the item in the middle of the interval, the search is narrowed to the lower half, otherwise the search is narrowed to the upper half.

IF the int table is sorted by a key, then when BINARY SEARCH is added to a WITH KEY statement... the "read" to the int table is performed at a binary level for maximum performance.

if N is the number of entries in your itab, linear search is done in O(N) and binary search is done in O(logN).

use it if your itab is big, just don't forget to sort it if it's a standard table.

Re: Sort statement performance

JozsefSzikszai — Tue, 11 Dec 2007 09:27:46 GMT

DATA: BEGIN OF MAKT_KEYTAB OCCURS 0,

<b>MANDT LIKE SYST-MANDT,</b> ==> you don't need this line

MATNR LIKE MAKT-MATNR,

SPRAS LIKE MAKT-SPRAS,

END OF MAKT_KEYTAB.

Re: Sort statement performance

Former Member — Tue, 11 Dec 2007 09:31:36 GMT

Don't think that any thing can be done to increase the performance of this SORT statement. Better try to split data in different tables.

Re: Sort statement performance

Former Member — Tue, 11 Dec 2007 09:33:00 GMT

Hi,

It should work, may be because of huge amount of data it is taking lot of time.

try to move the MANDT field into last postion and then try.

reward if needful.

Thanks,

Sreeram.

Re: Sort statement performance

Former Member — Tue, 11 Dec 2007 09:38:58 GMT

Hi,

You dont need to use MANDT and declaration there in internal table.

Use SORT statement including ASCENDING oor DESCENDING statement after that.

For e.g SORT INT_TAB ASCENDING BY MATNR SPRAS .

General Syntax :

SORT <itab> [ASCENDING|DESCENDING] [AS TEXT] [STABLE].

Thanks,

Sakthi C