Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Oracle SQL updates (with java)?

  • 07-04-2010 09:31AM
    #1
    Balmark
    Registered Users, Registered Users 2 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

  • #2
    Tom Dunne
    Registered Users, Registered Users 2 Posts: 23,202 ✭✭✭✭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