topic Re: ABAP syntax 7.5 in Application Development and Automation Discussions

ABAP syntax 7.5

ishwarya_doss — Mon, 09 Mar 2020 08:57:06 GMT

Hi All,

New ABAP syntaxes are easy to use. But, on considering the performance we got the below doubt.

New read itab statements are not performing binary search anywhere. When we use new READ syntaxes in ORACLE DB, it may affect the performance , right? As we always sort and do binary search in our traditional way

Please suggest!

Re: ABAP syntax 7.5

FredericGirod — Mon, 09 Mar 2020 08:59:35 GMT

READ is a statement to read data from memory, not database, so no direct link with oracle.

If you want a binary search on a table, you just have to declare it as SORTED table

Re: ABAP syntax 7.5

former_member1716 — Mon, 09 Mar 2020 09:06:53 GMT

anabaperlife,

I don't think you will have performance impact , recommend you to go through the below Threads which will help you with the answer.

THREAD1

THREAD2

Regards!

Re: ABAP syntax 7.5

Jelena_Perfiljeva — Mon, 09 Mar 2020 20:40:48 GMT

The "traditional" way you're describing was not good since the 1990s.

I sincerely hope that by "we" you are describing a college/training study group. The thought that professional ABAP developers are unable to distinguish between the DB and memory processing would be deeply troubling...

Re: ABAP syntax 7.5

keremkoseoglu — Tue, 10 Mar 2020 05:17:35 GMT

Using hashed / sorted table whenever possible would increase the performance + they can be used within the scope of new ABAP syntax.