topic Re: Performance in Application Development and Automation Discussions

Performance

Former Member — Tue, 02 Sep 2008 18:21:18 GMT

Which one is better performance wise?

Select single * or Read with Binary Search?

Which one will take lesser time?

What are the reasons for that?

Thanks,

Archana.

Re: Performance

Former Member — Tue, 02 Sep 2008 18:25:05 GMT

SAP work's on 3 tier arch.

Read take's lesser time than select single why because read statement happens n application layer whereas select single will go to the DB table to fetch data here where condition is important based on which indexes will be used , so if the where cluase contains fields other than key and indexes fields it would take much longer time to fetch.

Note : before doing read binary search sort the itab.

Edited by: karthik arunachalam on Sep 3, 2008 12:00 AM

Re: Performance

Former Member — Tue, 02 Sep 2008 18:37:55 GMT

Karthik, thank you for the reply.

We would do a Select before read as well right ?

So wont the select into table and read time and Select single * time be same?

Thanks,

Archana.

Re: Performance

Former Member — Tue, 02 Sep 2008 18:57:59 GMT

Mmmmm.... Select single hits the database now and then, the connectivity between the database and application layer will cost more time. In lay man terms Its like this you have a rack full of books you pull all the necessary books once and use it for reference thatu2019s one type and the other is when ever you need to refer a book you go to the rack and pick it up and refer the time taken for you to reach the rack will consume time rite!!!

Hope you are clear with the above explanation.

Re: Performance

rodrigo_paisante3 — Tue, 02 Sep 2008 19:46:07 GMT

Hi,

Did you try the SE30 (Tips and Tricks button)?

You can code two diferent codes and compare time.

Re: Performance

Former Member — Tue, 02 Sep 2008 21:17:28 GMT

read with binary search is only necessary if you have a lot of records in you're internal table (>10.000 for instance)

otherwise you won't notice.

kind regards

arthur de smidt

Re: Performance

Former Member — Wed, 03 Sep 2008 05:40:52 GMT

Obviously "Read Statement" after sorted is good.

Still this question is unanswered. How pity?

Re: Performance

JozsefSzikszai — Wed, 03 Sep 2008 06:37:43 GMT


> Which one is better performance wise?
> Select single * or Read with Binary Search?

it does not make much sense to compare these two statements, because they are used for different purposes! They are not replacing each other!