>-----Original Message----- >From: Waynn Lue [mailto:[EMAIL PROTECTED] >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 ><[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]