Re: Analysis: INSERT ON DUPLICATE UPDATE VS UPDATE

[Walter Trapa]

I didn't know BSSCODE could be used (I tried to find a post how to format the test in this forum without any luck.

The column in the data is (I) for SQL statement with INSERT ON DUPLICATE
And (U) for the SQL statement with for the same table, do UPDATE only.
(I) Insert on Duplicates Update
(U) Update only

for for the following example is was just:
Using the insert on duplicate, where the insert ALWAYS fails because key, that ON DUPLICATE update was done 1/200s = or 200 per second
In the case of just using UPDATE, the operation could be done at 350 per second.
Using one connection.

NDB
Connections: 1
(I) 200
(U) 350
Inc: 75%

Regarding the version of NDB and MYSQL, I agree, we are working in a plan to migrate, but with millions of records means to shutdown production for a matter of hours (according to the DBA Team).