Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Constant SQL Querys to send "signals"

by perlfan (Curate)
on Jun 21, 2016 at 21:58 UTC ( #1166222=note: print w/replies, xml ) Need Help??


in reply to Constant SQL Querys to send "signals"

If I am understanding correctly what you want is a producer-consumer (work queue model); I'd recommend using Redis and a worker daemon that manages a set of child processes to do the work.

Here's general Perl/Redis related talk on the matter.

Work Queueing With Redis

Basically, the web request results in "work" getting pushed on to a queue. There are then worker daemons that pop the work off the queue. It's at this point that your INSERTs happen.
  • Comment on Re: Constant SQL Querys to send "signals"

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1166222]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (8)
As of 2020-05-27 09:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    If programming languages were movie genres, Perl would be:















    Results (154 votes). Check out past polls.

    Notices?