View Single Post
  #1 (permalink)  
Old 06-06-2008, 12:30 AM
Ndt Ndt is offline
Member
 
Join Date: Jun 2008
Posts: 6
Ndt is on a distinguished road
How can I improve the execution time of a Java Project
Hi,

I have a Java project which does:

1> connect to DB2 to collect the account information (here I use DKDDO Method) and put into an ArrayList which has 51000 records

2> Loop of Array List until it ends
a> Connect to Content Manager (using CMBConnection, CMBSearchResults, CMBDataManagement) to get the documents belong to the account.
b> If found, create folder in F: drive and copy all documents related to that account to that folder (name same as Account No).

Since we are testing, 50990 records has the same Account No (which has 6 documents related to it), only 10 other records has 10 different Account No (which various documents related to it).

My application ran and complete successfully in 13 hours and 20 minutes. Which I calculated almost 1 second per account (with 6 documents related) or 0.15 sec per documents.

My boss claimed it is too long and asking me to improve the speed of my application. Would you like to show me how to do that ? Thanks a lot.
Attached Files
File Type: txt TConnect.txt (3.6 KB, 9 views)
File Type: txt TSearch .txt (14.7 KB, 4 views)
File Type: txt LoanSale .txt (18.7 KB, 2 views)
Reply With Quote
Sponsored Links