in reply to Database queue logic
I would add a timestamp column to my process list.
Any process would:
*the 10 Minutes are subject to fiddling
Any process would:
- select all processes that have a null timestamp or a timestamp that's older than 10* Minutes
- update all selected processes with the timestamp of now.
- process all selected processes
- delete processed processes
*the 10 Minutes are subject to fiddling
In Section
Seekers of Perl Wisdom