Sathish Ramadas

Greenhorn
+ Follow
since Dec 06, 2005
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by 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.
16 years ago
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.
16 years ago
Do you have any for installing Axis on Weblogic.?

Thanks
16 years ago
ALL

I have learnt how to use webservice on Axis server.

How do i install axis webservice on Weblogic server ?

Thanks.
16 years ago