I apologize if this question has been asked in the past. I am looking to implement a queueing layer similar to Oracle AQ for mysql. It uses a feature called skip locks that allows you to run a statement like:
select * from table for update skip locked I have been unable to locate this type of feature in Mysql. I know it exists in SQL Server as READPAST. Has anyone discussed this in the past? I am interested in implementing it if people would think it is useful. It is a great feature for parallelizing applications and for enterprise queueing. If nobody has discussed this, I will start reading the source to see how to implement. Thanks for your input! Mike Mangino --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php