Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL) |
If you take a look at actual benchmark data, like this for example:
https://www.facebook.com/notes/mysql-at-...006035932/ Then the performance issue seems pretty benign. Consider the link that shows an image of the results in a graph. I'm not saying there is no performance issue, but given the limited use case where it is not know if a record exists, then it's probably nothing to worry about. I found myself needing this recently. |
Messages In This Thread |
Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL) - by skunkbad - 09-04-2016, 11:28 AM
RE: Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL) - by InsiteFX - 09-05-2016, 04:45 AM
RE: Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL) - by skunkbad - 09-05-2016, 02:48 PM
RE: Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL) - by InsiteFX - 09-06-2016, 03:17 AM
RE: Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL) - by dave friend - 09-07-2016, 03:06 PM
RE: Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL) - by skunkbad - 09-07-2016, 04:22 PM
|