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

["Jerry Schwartz" <jschwartz@xxxxxxxxxxxxxxxx>]

>-----Original Message-----
>From: Waynn Lue [mailto:waynnlue@xxxxxxxxx]
>Sent: Monday, June 30, 2008 8:01 PM
>To: Jerry Schwartz
>Cc: MySQL List
>Subject: Re: Queues on MySQL?
>
>Thanks for the suggestion--is that essentially using
>http://www.php.net/posix_mkfifo within PHP?
>
[JS] Yes, that's what I had in mind. Be warned, though: I've never used this
from PHP; and, although I found no references to this in the PHP
documentation, I couldn't find the POSIX functions in a Windows
installation.

>On Mon, Jun 30, 2008 at 7:11 AM, Jerry Schwartz
><jschwartz@xxxxxxxxxxxxxxxx> wrote:
>>>-----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