09-02-2008 7:21 PM
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.
09-02-2008 7:25 PM
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
09-02-2008 7:25 PM
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
09-02-2008 7:37 PM
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.
09-02-2008 8:46 PM
Hi,
Did you try the SE30 (Tips and Tricks button)?
You can code two diferent codes and compare time.
09-02-2008 10:17 PM
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
09-02-2008 7:57 PM
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.
09-03-2008 6:40 AM
Obviously "Read Statement" after sorted is good.
Still this question is unanswered. How pity?
09-03-2008 7:37 AM
>
> 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!