How to do batch update for high number of records?

[Former Member]

Hello friends,

I have internal table i_tab with 500000 records,

and i want to update all these records in the database. I have a Function module to update this records.

so , if i do like...

Loop at Itab
	CALL FUNCTION 'UPDATE_DATA'         " Any update function
		IMPORTING
			field1 = field 1
		TABLES
			ev_table = I_TAB[]  " 500000 records

Endloop.

But It is taking too much time.

Does any body know about how can I update records in the batch?

like....batch of 2500 records at the time.

Please give me the example or code for this.

Thanks in advance,

Ronny

[Former Member]

you can loop at main table & keep appending data to temp itab then when count reaches 10,000

CALL FUNCTION 'xxxxxxxx'

STARTING NEW TASK 'call1'

ON END OF TASK

you can collect err msg for all the calls.

this will run function module calls parallel