>-----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]
