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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
