MySQL Forums
Forum List  »  Performance

Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
Posted by: Peter Brawley
Date: May 24, 2021 11:50AM

Evidently BBCode table tags are broken here, so your post is unreadable. I turned it into a utf-8 html page then copy/pasted it here ...

INNODB (Operation per second)
Num Con		                        1		5		10
INSERT + ON DUPLICATE UPDATE 		580		520		475
UPDATE ONLY		                630		600		590
 NDB (2 Data nodes, 1 SQL API, 1 MGM) (Operation per second)
Num Con		                        1		5	        10
INSERT + ON DUPLICATE UPDATE		200		215	        115
UPDATE ONLY		                350		380	        390

... which seems to say ...

(i) your insert on duplicate key test code is slower than your update code, but as you say, they're not strictly comparable

(ii) using 5.6, NDB is slower than InnoDB

So, what's your question?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE
425
May 24, 2021 11:50AM


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.