This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Threads and Synchronization and the fly likes How to speed up Batch Process Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Threads and Synchronization
Bookmark "How to speed up Batch Process" Watch "How to speed up Batch Process" New topic
Author

How to speed up Batch Process

kanna pol
Greenhorn

Joined: Nov 08, 2004
Posts: 1
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

Joined: Jan 29, 2002
Posts: 62
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to speed up Batch Process
 
Similar Threads
Process the multiple records in a file by Producer/consumer concept using Multithreading
DAtalayer design approaches
Uploading 4000 records in 1 minute
Firing SQLs in Batch to enhance performance
Batch updation failure because of duplicate records