topic parallel processing of database in Application Development and Automation Discussions

parallel processing of database

Former Member — Thu, 21 Jun 2007 06:47:58 GMT

hi friends.

if a internal table contains a lakh. how to divide into four and access it parallely. can anyone help. please send me the sample coding..

Re: parallel processing of database

Former Member — Thu, 21 Jun 2007 06:50:27 GMT

hi,

u can write select statment like this and move into four different itab's .

select * from <databasetable> into <itab> upto 25 000 rows where condition.

and second one is..

select * from <databasetable> into <itab> where keyfield <b>ge</b> '25000' and keyfield <b>le</b> '50000'.

like this u can write for third and fourth.

reward points if useful,

regards,

seshu.

Re: parallel processing of database

Former Member — Thu, 21 Jun 2007 07:02:39 GMT

hi ,

i have to update in a single internal table. do anyone have idea about that

Re: parallel processing of database

Former Member — Thu, 21 Jun 2007 11:23:23 GMT

You are saying that u have an internal table containing a lakh records, and u want to distribute it into four internal tables(having the same structure of course)

Re: parallel processing of database

Former Member — Thu, 21 Jun 2007 23:53:13 GMT

Take a read through SAP's program RUTBTPA0 - particularly the example code towards the bottom, and the comments which describes its use:

* Your program is suited for parallelization, if:
*   it determines a list of objects
*   and then loops over this list doing some function for each object
* Then you can start tasks in parallel each working on a subset
* of objects and finally merging the results of these tasks.

Re: parallel processing of database

Former Member — Fri, 22 Jun 2007 04:24:40 GMT

hi tripat,

i saying that we are getting lakhs of record for the condition we are using.for that we have to check whether it is greater than lakh we have to divide it by 4 and access it with on internal table by processing 25000 at the same time it has to process from next record in the same internal table..