Do you ever use "ON DUPLICATE KEY UPDATE"? (MySQL) |
I think the performance hit on this sort of statement comes when you are trying to update the key of an existing record. Otherwise, it performs on par with an insert or update.
I confess I did not look that closely at your code but isn't what you're doing basically served by $this->db->replace() in Query Builder? |
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
|