Re: mySQL table as Perl Queue

2002-11-07 Thread rick
I've done a specialized, high-volume FIFO queue implementation using MySql that performs extremely well - if your concern is speed I think you'll likely do fine. Of course, speed is relative to each solution - what kind of response time for enqueue/deque operations do you require? In my situat

Re: mySQL table as Perl Queue

2002-11-06 Thread Jeremy Zawodny
On Thu, Nov 07, 2002 at 12:03:12AM -0500, lewellen wrote: > Hi all- > > I would like to use a mySQL table as a huge FIFO queue (too big > for a hash) in a Perl program. However, I am worried about speed. > A standard way to get an item off the queue would be to issue a > SELECT statement sorted

mySQL table as Perl Queue

2002-11-06 Thread lewellen
Hi all- I would like to use a mySQL table as a huge FIFO queue (too big for a hash) in a Perl program. However, I am worried about speed. A standard way to get an item off the queue would be to issue a SELECT statement sorted on the index, and then to just make one call to a row-fetching method