I removed the collection classes and tried a direct insertion of data into database.
Also i noticed database insert timing alone. I calculated start time before database action starts and ends. It took more time than when i used collection classes. For hundred thousand records it's taking 14 mins.
when i test database insertion alone, i am not reading the data from the file and inserting it...just a database insertion (hard coded value in the statment values) alone takes more time.
When I used to read data from flat file, I use to store it in collection classes (arraylist) and insert into database. In the mean time, when the ararylist size reaches 15000, I will clear it and start the iteration again. So database conenction also get refreshed during this time.
Is it because of single database connection inserting hundred thousand records takes me more time (This test is a direct database insertion wihtout using collection classes).
PLease suggest me.