topic Re: sorting technique in Application Development and Automation Discussions

sorting technique

Former Member — Wed, 27 Aug 2008 12:13:55 GMT

What is the advantage/disadvantage (over each other) of sorting using the 2 options below?

1. sorting a table through the select command (Ex. "into sorted table").

2. sorting a table using the sort keyword (Ex. "sort table itab by carrid").

thanks for the help.

Re: sorting technique

Former Member — Wed, 27 Aug 2008 12:15:36 GMT

sorting the table using select may take more time and where as the second one is consumes less time

Re: sorting technique

Former Member — Wed, 27 Aug 2008 12:17:28 GMT

Jabbar Junzo

by performance wise

sort table itab by carrid this one is better

because here we process in ABAP memory during runtime

but in first case ( it directly deal with records in Database it consume more time to fetch a record)

regards

deva

Re: sorting technique

Former Member — Wed, 27 Aug 2008 12:17:31 GMT

One you are sorting the data at the sametime while retriving it form database and the 2nd one you are sorting after getting the data in your internal table.

So if there is selection criteria its better to sort after retriving the data in your internal table, performance wise this is better

With luck,

Pritam.

Re: sorting technique

Former Member — Wed, 27 Aug 2008 12:18:01 GMT

Hi,

By performance wise 2 nd statement is fine bz SORT is a abap keyword.

So after getting data into int table u have to use sort int table. If in the select query u use sorting then the performance will be down bz for every select statement the data going to sort.

thanks,

Edited by: Baidyanath Subudhi on Aug 27, 2008 5:48 PM

Re: sorting technique

Former Member — Wed, 27 Aug 2008 12:18:06 GMT

Hi,

A Very good question.

Sorting with select query makes your internal table data as in the sorted by option.But it takes much time as the burdon on the database server is more.

Where as Sort itab makes more performance.

Regards,

Rama.

Re: sorting technique

Former Member — Wed, 27 Aug 2008 12:18:58 GMT

disadvantage at No. 1 is that you are using a sorted table.

means you gotta take care when working with it. E.G. Append will not work tho you gotta insert instead.

another disadvantage is that it uses more time than just doing an array fetch and the sorting the stuff.

Re: sorting technique

Former Member — Wed, 27 Aug 2008 12:20:46 GMT

Hi,

For first select ... into sorted table...

it has to select the data as well as sort at same time so lot of performance issue.

for second sort itab... its juz matter of sorting so not that much overhead..

thanx.

Re: sorting technique

Former Member — Wed, 27 Aug 2008 12:21:40 GMT

thanks people. I gave points to all of you.