How to increase the performance for a module running parallely (using asynchronous method) in...

1. 
   Some people says buffer for the table will create issue while running a module in appserver may I know the reason.
   
   
2. 
   In my Main module I’m using For each ... break by condition to read the record from DB which needs to read 100k of records within minute. So if I'm not using Break By condition in the For each loop and running batch parallel (using asynchronous method based on input count will create multiple session) through appserver then I can able to improve performance little bit but i need to improve the performance even more what else i can do?Please suggest me..
   

eg: RUN report.p ON SERVER sh ASYNCHRONOUS SET ah EVENT-PROCEDURE "reportDone" IN THIS-PROCEDURE (input aaaa, OUTPUT yyy AS INT).

1. Buffer vs Temp table for a table which will give high performance?

Continue reading...