I have a stored procedure that watches a table in the database. This Store 
procedure then executes call rocker depending on the tasks placed in the table. 
Depending on what is put into the record of the table it will cell multiple 
workers.  Each worker could run for un undetermined amount of time. But usually 
they are pretty quick. 

The problem is that is I put in multiple requests. The call worker seems to 
lose track of the process running. For instance I have a worker called upload 
photo. This worker takes a photo from the table and places it in a folder on 
the server and generates three different sized thumbnails. But I have found 
that my loop pushing photos to the server moves so fast it outraces the call 
worker and causes requested workers to fail to finish processing. 

I have found the docs discussion about using signals. But I am wondering if 
there is a best practice for using this in the loop to prevent my from doing a 
call worker to a busy worker but not stall the event looks on the server.

**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to