MySQL Forums
Forum List  »  General

Re: update delayed?
Posted by: Jason Collison
Date: January 14, 2005 05:59PM

That's slightly different from insert delayed, because the low_priority update will block. And possibly for a very long time.

I don't know of any way to get true delayed behaviour without having a different thread/process do the actual updates. Which wouldn't really be all that hard, but might be overkill for the original poster's needs. Or another option... say this is a CGI. Queue up all of the updates in a buffer. After displaying the response to the user, do an fclose on stdout and then run all those updates with low_priority. This way it doesn't matter how long the updates block. One could use a similar approach for just about anything.

Options: ReplyQuote


Subject
Written By
Posted
January 14, 2005 05:31PM
January 14, 2005 05:47PM
Re: update delayed?
January 14, 2005 05:59PM


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.