Repeat a query with some interval to aggregate output

Registered by Bjorn Melinder

Add a way to repeat a query multiple times and aggregate the output. Can use this to track statistics over time. For instance:

REPEAT -n10 -i1000 SELECT NOW(), COUNT(*) FROM foo;

Will run the query 10 times with 1000ms interval. Any produced rows should be send in the same containing result set so the presenter and dest can render it as one single result set, e.g.

+-------------+----------------+
+ Date + Count +
+-------------+----------------+
+2009-..01 + 123 +
+2009-..02 + 125 +
...

and so on.

An example usage would also be to send the final result to a chart so you can see a diagram over time of the statistics you've observed.

Blueprint information

Status:
Not started
Approver:
None
Priority:
Undefined
Drafter:
None
Direction:
Needs approval
Assignee:
None
Definition:
New
Series goal:
None
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.