Re: PreparedStatement does not work with multiple values Insert
Posted by: David Wynter
Date: April 09, 2005 07:59AM

Well this one was my fault, clearParameters() was hidden in there from old code I converted across to dynamically build the statement and set the values.

Now have PreparedStatement with 40 sets of 38 column values for the grandchild records and PreparedStatements with ON DUPLICATE UPDATE for the child and parent records. Now runs at about 55% of the performance of MS SQL on the same hardware and same records.

Might yet have a crack at getting the multiQueries to work as this is likely to be even faster.

David

Options: ReplyQuote


Subject
Written By
Posted
Re: PreparedStatement does not work with multiple values Insert
April 09, 2005 07:59AM


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.