Sathish Ramadas

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.

Thanks for your suggestions...

Lakh Lines -> Hundred Thousand Lines.

When i looked at the executions, i don't see any delay in storing data into the collections classes and retreiving it.

Let me check it without using collection classes and just directly inserting the data into database.

Thanks.

Do you have any for installing Axis on Weblogic.?

Thanks

ALL

I have learnt how to use webservice on Axis server.

How do i install axis webservice on Weblogic server ?

Thanks.