Re: update delayed?
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.
Subject
Written By
Posted
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.