You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Diff. between Set Processing & Row-By-Row Processing.......

4 replies [Last post]
maheshkundu's picture
User offline. Last seen 10 years 20 weeks ago. Offline
Joined: 05/16/2008
Posts: 12

Hi Frnds,

What's the diff between Set Processing And Row-By-Row Processing? Though Set Processing Basically used in App Engine Program.But What's the concept of it.Kindly give ur comment with an example.

Thanx in advance

Lepa's picture
User offline. Last seen 2 years 6 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Diff. between Set Processing & Row-By-Row Processing.......

Hi maheshkundu,

The same question has been asked before on the forum and here is the link. Cheers!

http://www.compshack.com/forum/peoplesoft/peoplesoft-technical/set-proce...

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

maheshkundu's picture
User offline. Last seen 10 years 20 weeks ago. Offline
Joined: 05/16/2008
Posts: 12
Re: Diff. between Set Processing & Row-By-Row Processing.......

hi
so wht's the difference of set processing from parallel processing??
can we use temp table for both set processing as well as parallel processing???

Lepa's picture
User offline. Last seen 2 years 6 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Diff. between Set Processing & Row-By-Row Processing.......

Temporary tables are used with Application Engine programs and are intended to provide parallel processing. Parallel or concurrent processing allows multiple instances of an Application Engine program to execute against the same tables while drastically reducing the risk for table contention.

By using the Temporary Table record type definition, you are able to define a record and the PS Build process will build multiple uniquely named copies of your Temporary Table as a pool.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Nitin's picture
User offline. Last seen 5 years 30 weeks ago. Offline
Joined: 06/30/2008
Posts: 73
Re: Diff. between Set Processing & Row-By-Row Processing.......

Set Based require grouping of Data and processing of group data in one shot.?
This can be acheived thru SQL.
Temporary table needs to be associated with AE to enable the Parallel Processing .

Regards
Nitin