topic Re: mutiple selects on one table in Application Development and Automation Discussions

mutiple selects on one table

Former Member — Mon, 10 Nov 2008 19:12:05 GMT

I have a table with 20,000 to 60,000 records. Using a select up to n rows statement how can i select 1000 records at a time, process the data, then grab the next 1000?

Re: mutiple selects on one table

former_member156446 — Mon, 10 Nov 2008 19:14:54 GMT

I guess that's not a performance oriented approach..

grab all into one internal table first and then process in batches...

Re: mutiple selects on one table

Former Member — Mon, 10 Nov 2008 19:16:00 GMT

Even if you use Select upto 1000 rows all the records matching the where condition is retrieved into the buffer but only 1000 records are fetched from buffer.

better not to use select upto in this case.

Re: mutiple selects on one table

Former Member — Mon, 10 Nov 2008 19:22:47 GMT

let me re-try this. currently i select all the records into an internal table. The problem is that i have to read that table line by line to pass it to a bapi causing a time out error. How can i break my itab so it process the information in batches?

Re: mutiple selects on one table

former_member194669 — Mon, 10 Nov 2008 19:30:44 GMT

Try something this way


loop at itab.
  move-corresponding itab to itab1.
  v_no = v_no + 1.
  if v_no = 1000.
     job_open.......
     submit <another report and call the bapi inside this program> and pass the internal table itab1.
     job_close......
     refresh itab1.
     clear v_no.
  endif.
endloop.

a®

Re: mutiple selects on one table

former_member156446 — Mon, 10 Nov 2008 19:44:02 GMT

The problem is that i have to read that table line by line to pass it to a bapi causing a time out error.

in the read table use the Binary Search addition for sure... it reduces the processing time of read to half.

Re: mutiple selects on one table

Former Member — Mon, 10 Nov 2008 20:12:03 GMT

Use the PACKAGE SIZE option of the SELECT statement.

Rob