Thanks for the suggestion--is that essentially using http://www.php.net/posix_mkfifo within PHP?
On Mon, Jun 30, 2008 at 7:11 AM, Jerry Schwartz <[EMAIL PROTECTED]> wrote: >>-----Original Message----- >>From: Waynn Lue [mailto:[EMAIL PROTECTED] >>Sent: Monday, June 30, 2008 6:04 AM >>To: MySQL List >>Subject: Queues on MySQL? >> >>Hey, >> >>I'm looking to write a queue backed by MySQL to enable batch updates >>of a system I'm writing. Essentially what I wanted to do was every >>time I want to enqueue, I just INSERT a new row into a table. Then I > [JS] Just a bit of a warning: in my (very old) experience, this is not the > most effective way of implementing a queue. Does your environment support > fifo files, or can you emulate them? They have a lot less overhead. > >>have a cron job that runs every X minutes, selects all the existing >>rows and does the actions, then deletes the rows that have been >>selected. It's a fairly simple algorithm, and not hard to implement, >>but I'm wondering if there are existing tools out there that do queues >>that will have additional functionality in case I ever want to change >>it. >> >>A quick Google search turned up links like http://q4m.31tools.com/, >>but I'm not sure what's a good one. >> >>Thanks, >>Waynn >> >>-- >>MySQL General Mailing List >>For list archives: http://lists.mysql.com/mysql >>To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >>infoshop.com > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
