Need help : degrading performance in record updates
- From: AkshayAOI@xxxxxxxxx
- Date: 10 May 2007 20:43:39 -0700
We are facing some problem in our batch application.
This java based application is reading a file with 25 lakh records
and
updating in Oracle DB.
The batch is commited after each 300 records.
We are taking a time stamp after each 10000 records.
What we have observed is, initial it was taking some 3-4 seconds to
update 10000 records.
The time required is increasing progressively.
After 12 Lakh records, now it is taking almost 10+ mins to update
10000 records.
I have failed to pin down a problem, for such continuously degrading
performance.
This is important for us because, we have such 16 files to upload.
And
this upload is just data preparation for the analysis that we need to
perform on one bug that is observed on production.
I think, Re-do logsize of Oracle should not be a problem since we are
committing every 300 records.
Any thoughts, as to why this problem of degrading performance could
be? And solutions if any?
Thanks in advance :-)
.
- Follow-Ups:
- Re: Need help : degrading performance in record updates
- From: tzvika.barenholz@xxxxxxxxx
- Re: Need help : degrading performance in record updates
- Prev by Date: Re: Where to store SQL statement
- Next by Date: oo-relational jdbc mapping approach
- Previous by thread: Rollback not working
- Next by thread: Re: Need help : degrading performance in record updates
- Index(es):
Relevant Pages
|
|
