Logic for Parallel Processing

[Former Member]

Hi All,

I have a requirement in which I should send large data from database table to Application server.

This program is a batch program and will run every day.

I have date in the selection screen for batch program.

i will have 8lakh data per day and this has to be sent to applcation server.

I got idea to do in Parallel processing. Can you suggest me the code how i can do parallel processing for large data.

[Former Member]

Hi Hari,

     You can find the logic SDN Wiki also if you can search you will find how to use. Pasting  the link from wiki http://wiki.sdn.sap.com/wiki/display/ABAP/Parallel+Processing.

Regards,

Midhun

[Former Member]

Hi Hari,

check some examples

http://wiki.sdn.sap.com/wiki/display/Snippets/ABAP+Code+for+Parallel+Cursor+-+Loop+Processing

Links without explanations are not permitted.

Message was edited by: Venkat Gowrishankar

[Former Member]

Parallel cursor and Parallel processing are different concepts.

[arindam_m]

Hi,

You can trigger multiple background jobs using the multiple background processes that are available. You can check the number of background processes available in SM50.

Also this is subject to the fact that the basic range of selection can process the data in parallel. i.e. facts like they access same tables for update or same entries in a particular table.

Some design level considerations have to be done like what is the range like say employee numbers or document numbers are generated after processing then not advisable not to as you can end up using same number ranges an thus may pick wrong document numbers or end up waiting for access.

Cheers,

Arindam