How can I improve the execution time of a Java Project
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.