topic Re: Select... endselect VS Select into an internal table in Application Development and Automation Discussions

Select... endselect VS Select into an internal table

Former Member — Thu, 23 Apr 2009 14:58:33 GMT

hi all,

which is the best alternative performance,

Select directly into an internal table or Select... endselect command.

thanks

Moderator message - Please do not ask or answer basic questions like this. Search the forum instead. Post locked

Edited by: Rob Burbank on Apr 23, 2009 11:13 AM

Re: Select... endselect VS Select into an internal table

Former Member — Thu, 23 Apr 2009 14:59:51 GMT

Hi,

Select into internal table is better perofrmance query. Because Select...End select working as loop statement.

Re: Select... endselect VS Select into an internal table

former_member156446 — Thu, 23 Apr 2009 15:03:04 GMT

select... endselect is also called as select loop.

so definitely select into internal table is better when you compare both.

Re: Select... endselect VS Select into an internal table

Former Member — Thu, 23 Apr 2009 15:03:13 GMT

Select into internal table is better, because the Database Cursor is opened only once in the DB.

Whenever you have performance comparison doubts u can do this.

go to SE30.

Click on Tips and tricks.

Write your code in both windows and click on measrure run time.

YOu will see which is faster.

Regards,

Ravi

Re: Select... endselect VS Select into an internal table

Former Member — Thu, 23 Apr 2009 15:07:17 GMT

Select into internal table is better, because the Database Cursor is opened only once in the DB.

Whenever you have performance comparison doubts u can do this.

go to SE30.

Click on Tips and tricks.

Write your code in both windows and click on measrure run time.

YOu will see which is faster.

In FAct you have a ready made example.

go to SE30.

Click on Tips and tricks.

On the left hand side pane, under

ABAP Objects Performance example->SQL Interface->Array Operations->SElect....into Table

docuble click on that and click on measure runtime.

(I got 331 microseconds for select-endselect over 47 micro seconds in select into table.

Regards,

Ravi

Re: Select... endselect VS Select into an internal table

faisalatsap — Thu, 23 Apr 2009 15:08:45 GMT

Hi,

I am also agree with all that Select into internal table is better.

Please Close this Thread if got your Idea Clear

Thanks and Best Regards,

Faisal