Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Oracle SQL updates (with java)?

Options
  • 07-04-2010 9:31am
    #1
    Balmark
    Registered Users Posts: 107 ✭✭


    Hey,

    Has anyone any experience with bulk updates programatically with oracle?

    At the moment, I've a procedure for an insert

    ->
    delete row
    insert row with new values

    creating a preparedstatement and adding new inserts (using the procedure call) to the batch, then executing them.. but its 'hella' slow .. I nuked most of the indexes on the tables and turned off all the triggers, but I'm still only getting about 60 inserts a second (60delete/inserts)

    Anyone have any idea what I can do to speed things up a little?


Comments

  • Options
    #2
    Tom Dunne
    Registered Users Posts: 23,212 ✭✭✭✭Tom Dunne


    Balmark wrote: »
    Anyone have any idea what I can do to speed things up a little?

    Commit every X rows? That should speed things up a bit.

    Is the Java running inside the DB or outside?


Advertisement