Pathologically Eclectic Rubbish Lister | |
PerlMonks |
Re: Database queue logicby Solo (Deacon) |
on Jun 14, 2005 at 17:33 UTC ( [id://466649]=note: print w/replies, xml ) | Need Help?? |
I would have a single process that watches and updates the table which farms records out to worker processes--pre-forking if performance dictates.
How fast do you want to check for new records? Rather than repeatedly querying the table, you might consider an insert trigger (not sure if that could work) or tailing a log file instead. --Solo
In Section
Seekers of Perl Wisdom
|
|