Skip to Content
avatar image
Former Member

Performance

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2008 at 06: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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 03, 2008 at 06: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!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 06: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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 03, 2008 at 05:40 AM

    Obviously "Read Statement" after sorted is good.

    Still this question is unanswered. How pity?

    Add comment
    10|10000 characters needed characters exceeded