best practice for continuous processing of data from database

I want to setup a computer to continuously ask a database for new data, process the new data and then write back the reults of the calculation to the database.

The new data will arive at 10-100 Hz for a few minutes and then pause for a few minutes. Should I set up a script, function, object, or somthing else to run indefinately to perform this task.

(I'm also thinking that the task should be performed as often as possible while the data is ariving but for the periods when there is no new data I only need to ask for new data every second or so, so I dont disturb the database too much)...

Answer 1

[Micke Malmström]

I guess I could use a timer object to schedule a lookup in the database? However, can I restart the timer? Or should I create a new one at the end of the code for the first timer