topic Select single in Application Development and Automation Discussions

Select single

Former Member — Mon, 20 Aug 2007 11:33:02 GMT

Can we use Select single inside the loop..? will it cause any performance issue....?

Regards,

Murugan Arumugam

Re: Select single

Former Member — Mon, 20 Aug 2007 11:34:57 GMT

try to avoid select statement inside loop it will decrease the performance

Re: Select single

Former Member — Mon, 20 Aug 2007 11:35:03 GMT

HI,

yaa u can.

but u can select only one row using this.

this is good compared to select * in performance wise.

rgds,

bharat.

Re: Select single

Former Member — Mon, 20 Aug 2007 11:35:07 GMT

You Can.

Are you using it for validation or reading data. If so then you may wish to use the

AT NEW command

So that you only do the read each time the where condition would change.

Re: Select single

Former Member — Mon, 20 Aug 2007 11:35:57 GMT

Hi,

Why u use select single in loop statement better write your query befor loop statement and then use read statement for use this data according to key field.

Rewards points if it is useful.

Re: Select single

Former Member — Mon, 20 Aug 2007 11:43:53 GMT

Hi,

there is no issues using like that.In select single u only have to take care whether the conditions used to fetch includes all primary key fields.

Re: Select single

Former Member — Mon, 20 Aug 2007 11:44:28 GMT

Hello,

Select statement inside a loop is not a good programming practice. It will make some performance issues. Instead of this u can select the record in to one internal table fist and u can use the read table command inside the loop statement. That is better.

Reward if helpful,

Regards,

LIJO JOHN

Re: Select single

Former Member — Mon, 20 Aug 2007 11:47:53 GMT

Hi Murugan,

As far as performance is concerned Select single is not advisable. Better would be, you retreive the data outside the loop into a internal table and then use READ statement. But if the amount of data is less then you can go for SELECT SINGLE also. It will serve your purpose.

It is a subjective matter and depends on the amount of data you are handling.

Rewards points if helpful

regards

Sourabh Verma

Re: Select single

Former Member — Mon, 20 Aug 2007 11:48:02 GMT

Hi,

Avoid select statement using inside loop

it will decrease the performance.

Re: Select single

Former Member — Mon, 20 Aug 2007 11:48:39 GMT

Hi murugan,

The Best answer i could get 4 u is this....

if you are 100% sure , you can't code a database join, then :

Theoretically , the "for all entries" clause has an advantage over a loop of select singel by primary key. This is becuase the abap interpreter can group together several rows in the itab into one select (see note 48230) so it could get the requested result using less conversations with the database.

The down side is that by doing so, the where predicates will not be a simple equation predicates, they may become "in" predicates and so on (see note 48230). This change in the sql may lead to a more costly access path.

So, unfortunatly, you will probably be forced to write and test both options and see which costs less.

by costs i mean total getpages or "in db2 time" for the whole workload, and not transaction elapsed time.)

as a rule of thumb I would lean to select single by primary key, over "for all entries" ... but as i said, its depends on several factors....

Above article is taken from...

http://blogs.ittoolbox.com/sap/db2/archives/for-all-entries-vs-db2-join-8912

Refer that too...

Hope it helps!!!

*Reward useful answers*

Regards,

Naveenan

Re: Select single

Former Member — Fri, 28 Sep 2007 07:30:35 GMT

Thanks a lot