Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: MASSIVE degradation of insert using sequence ID's via JDBC on 9i?

Re: MASSIVE degradation of insert using sequence ID's via JDBC on 9i?

From: HansF <News.Hans_at_telus.net>
Date: Mon, 27 Jun 2005 14:41:04 GMT
Message-Id: <pan.2005.06.27.14.44.20.789647@telus.net> 





On Mon, 27 Jun 2005 15:17:52 +0100, bugbear interested us by writing:



Curious - why are you committing after each insert (inside the loop)?  



While there may be legit reasons, based on your description I don't
understand the need for it at that point, and it will certainly
slow things down



Have you had a chance to read Tom Kyte's 'Effective Oracle by Design'?  


-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***


Received on Mon Jun 27 2005 - 09:41:04 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US