Skip navigation links

MySQL Forums :: Newbie :: What is the best way to implement a queue system?


Advanced Search

What is the best way to implement a queue system?
Posted by: Nigel Higgs ()
Date: August 01, 2009 04:31PM

I am very new to MySQL and PHP (started 2 weeks ago), and was wondering if someone could give me some advice on the best ways to create a queue system.
Here are the details of the queue system I need:

- The queue system I need will have a limited number of entries (I think it'll be about 1000).
- If the queue is full no new items will be allowed to be added to it.
- New items need to be added to the end of the queue.
- The first entry in the queue will need to be read then, as long as a certain condition has been met, moved to the end of the queue again, otherwise is deleted.
- The condition that needs to be met has yet to be decided, but it will be something along the lines of, the entry has reached the top of the queue less than x times, or the entry has been in the queue less than x days.

Speed is not really an issue as I only expect the database to be modified every few minutes at the most, but obviously, the more efficient the methods are the better.
So, how would people recommend creating this system?

Many Thanks,
Nigel

Options: ReplyQuote


Subject Written By Posted
What is the best way to implement a queue system? Nigel Higgs 08/01/2009 04:31PM
Re: What is the best way to implement a queue system? Peter Brawley 08/01/2009 05:19PM
Re: What is the best way to implement a queue system? Nigel Higgs 08/02/2009 06:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.