topic Best performance in Application Development and Automation Discussions

Best performance

Former Member — Fri, 30 Jan 2015 10:59:14 GMT

Hi All, I have a performance issue with select query where i am using for all entries. Is performance improved if i convert that for all entries into ranges table ? Regards, Praveen

Re: Best performance

SharathYaralkattimath — Fri, 30 Jan 2015 11:02:31 GMT

Not required, just check the for all entries table is not initial.

for filling the ranges, you need to loop the table & fill the range, this will increase program execution time.

Re: Best performance

Former Member — Fri, 30 Jan 2015 11:06:17 GMT

Hi Praveen,

At some point, it`s same, i think. All the content will convert to 'OR' condition in native sql.

So if this all entires itab is very big, you`d better just select all data from dbtable directly, do not use 'ALL ENTIRES'.

regards,

Archer

Re: Best performance

vinodkumar_thangavel — Fri, 30 Jan 2015 11:12:04 GMT

HI,

For performance based if u use FOR ALL ENTRIES it will be good instead of using ranges because the FOR ALL ENTRIES works in the buffering concept .

Regards,

Vinodkumar.

Re: Best performance

Former Member — Fri, 30 Jan 2015 12:15:59 GMT

Can you please post the select query ? and also let us know the total entries in the table on which for all entries is performed. is initial check present for The table on which for all entries is performed ?

Re: Best performance

robson_soares — Fri, 30 Jan 2015 14:51:07 GMT

I suggest some actions with respect to the fields that will be used as key in the FOR ALL ENTRIES table (FAE):

- Ensure that they are not empty;

- Delete the repeated values;

- Sort it out.

And as said before, verify that the FAE table is not empty.

Using intervals is not a good idea because, depending on database system, there may be a limit of rows within the range.

Re: Best performance

Former Member — Sat, 31 Jan 2015 09:21:09 GMT

hi praveen,

If the internal table has numerous records and there is a lookup then it is better to make it hashed table type.

by making it hashed table performance will sure improve.