On Thu, 14 Mar 2002, Jean-Paul ARGUDO wrote:
> This daemon wakes up every 5 seconds. It scans (SELECT...) for new
> insert in a table (lika trigger). When new tuples are found, it
> launches the work. The work consist in computing total sales of a big
> store...
You might find it worthwhile to investigate "listen" and
"notify" -- combined with a rule or trigger, you can get
this effect in near-real-time
You'll probably still want a sleep(5) at the end of the
loop so you can batch a reasonable number of updates if
there's a lot going on.
Matthew.