Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007

    Question Unanswered: How to increase performance while updating many rows

    Hi I am using Oracle 9i for my core Java project through Hibernate 3.X

    While saving the hibernate session i need to update 73000 objects(rows) in 3 tables.

    It is taking more than 24 hours..some times not at all completing.

    Is there any way to do workaround without a code change( I should not at this moment) like increasing hibernate memory or oracle channel memory (i guess there would be something..not sure about these) ....

    Any help is highly appreciated


  2. #2
    Join Date
    Nov 2003
    Provided Answers: 8
    Check the generated statements and analyse their execution plan. Maybe an index can help here.
    Updating 73000 rows should not take 24 hours. Is Hibernate using one statement per row? If yes, you might want to check if Hibernate can be configured to use less statements (e.g. using IN clauses or something)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts