***BOGO*** RE: Queues on MySQL?

["Jerry Schwartz" <jschwartz@xxxxxxxxxxxxxxxx>]

>-----Original Message-----
>From: Waynn Lue [mailto:waynnlue@xxxxxxxxx]
>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/mysql?unsub=jschwartz@the-
>infoshop.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx