Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to speed up Batch Process

 
kanna pol
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI all

I want to speed up the processing time of my batch process which is taking hours for processing 10000+ records.I am using stateless session beans with DAO Beans to fetch\write Records in to data base .I use Prepared Statements for record insertion with more than 100 prepared statements for each record insertion.

Do we have any other technique to speed up insertion\fetching of data , is there any chance to process bulk data parallely as threads..

Can anyone help me out in implementating this.

Thanks in advance

kanna
 
Napa Sreedhar
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I believe you are using something like statement.executeBatch().
Here what we do is sending a batch of insert querys to database at the same time.

If you are already using this way, pls provide a code snippet and data base table structure. We can work out then.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic