Skip to Content
author's profile photo
Former Member

data fetch optimisation

Hello All,

can anyone tell which is best way to fetch data having more than 50L records. I tried with <b>open cursors</b>,but is it a good way. what are its disadvantages.

Regards,

Rushi

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Posted on Sep 27, 2007 at 12:49 PM

    what is 50L ?

    And where are the 50L, in the database or do you want to select 50L records?

    If the last one ist 'yes', then comes the question, '0why do you need that many records'?

    If you must read large number of records, then you should split the result into packages of size 10.000 records. For the splitting you need the open cursor technique, it is the only possibilty to continue reading.

    Siegfried

    Add comment
    10|10000 characters needed characters exceeded

    • I guess he/she means 50K as in fifty thousand.

      Back to the subject, presuming L must be K.

      In my opinion 50.000 records isn't that much in SAP, try to select all in an itab and time how long this took. (with statement get run time field)

      Kind regards, Rob Dielemans

  • Posted on Sep 28, 2007 at 11:23 AM

    L = 1000, I think iit is rather the same as the Japanese 'ichi man' meaning 10.000.

    And 500.000 is not so small anymore.

    Add comment
    10|10000 characters needed characters exceeded