Skip to Content
0
Former Member
Jul 22, 2008 at 12:34 PM

Which is More Efficient? Selects from DB or Load to ITAB for Read?

37 Views

The DB table is not huge. Do I continually do selects from the DB table while I am looping in the program at my internal table to get the values I need?

Or, do I load the DB table to an internal table in my program during initialization, then do Read itab with key, get the sy-tabix, loop at the internal table using sy-tabix, and get the fields I need?

Which is most efficient? I am interested in all points of view, or suggestions.

Thank-You.