Re: Very slow performance??
Posted by: Vincent Chow
Date: November 02, 2004 10:32AM

Thanks Mark,

It seems it is much better to pack whatever needs to insert or update into a single sql statement and ship it to the server.

Then I have another question, when I need to update a bunch of rows in a table, would it be better if I just delete the affected rows and reinsert them in a single statement? This way, only 2 statements need to be executed. One for delete existing entries, and another one for reinsert them back.

From what I've read so far, there is a batch update, but someone points out that the driver just does the update one by one, which in this case, back to the original performance that I got.

Also, is there any way to temporarily disable foreign key checking if I choose to do batch delete, and insert?

Probably it is the wrong forum to post this question.......

Options: ReplyQuote

Written By
October 25, 2004 11:16AM
November 01, 2004 11:40AM
Re: Very slow performance??
November 02, 2004 10:32AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.