Re: Poor performance vs. MSSQL with JDBC
Posted by: David Wynter
Date: April 07, 2005 11:43AM

Well I switched to using the INSERT with multiple value sets and that works.

InnoDb forum does not seems to be interested in performance that is, admitted only one order of magnitude slower, than MS SQL on the same server, no reponse to my posting.

The problem seems to relate to the ON DUPLICATE UPDATE, at least I guess it is. With MS SQL I had to manage the capture of the duplicate key from the SQLException it threw then re-submit an Update. But this seems to be more efficient than the admittedly clean sinlge statement MySQL provides.

I spotted someone elses SHOW InnoDb STATUS output and now see that a deadlock is explicitly reported so I am not getting any of those.

Can you tell me if I can use a PreparedStatement when using the multiple value sets with INSERT? Also is there a limit on the size of the String passed to Statement.execute(String query)?

Thx,

David

Options: ReplyQuote


Subject
Written By
Posted
Re: Poor performance vs. MSSQL with JDBC
April 07, 2005 11:43AM


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.