TalkPHP - View Single Post

delayedinsanity · 11-26-2009, 01:41 AM

I didn't realize this before, but apparently you can't use HIGH_PRIORITY on REPLACE statements, only with INSERT queries - does anybody know if this is because REPLACE are already considered high priority? It doesn't clarify in the dox whether they are or not.

If not, I wonder if reverting to INSERT HIGH_PRIORITY IGNORE would be better practice for critical queries?

11-26-2009, 01:41 AM	#1 (permalink)
delayedinsanity is cute and cuddly Join Date: Mar 2008 Location: Vegas, Baby Posts: 963 Thanks: 31	No high_priority replace? I didn't realize this before, but apparently you can't use HIGH_PRIORITY on REPLACE statements, only with INSERT queries - does anybody know if this is because REPLACE are already considered high priority? It doesn't clarify in the dox whether they are or not. If not, I wonder if reverting to INSERT HIGH_PRIORITY IGNORE would be better practice for critical queries?