Do AD-HOC reports run one after another or concurrently?

Do AD-HOC reports run one after another or concurrently?

by Andrew C -
Number of replies: 3

Hi Tim,

The Ad-HOC Reporting Plugin has got to be my favourite plugin in Moodle. Thank you for writing this.

I'd like to know if the AD-HOC reports run one after another or concurrently? I couldn't find this in the documentation.

Thanks, Andrew

Average of ratings: -
In reply to Andrew C

Re: Do AD-HOC reports run one after another or concurrently?

by Andrew C -

To clarify, I have created several reports that run on 'Scheduled, on the first day of each week'.

I'd like to know if the AD-HOC block runs through the first scheduled query, waits for it to finish, then moves onto the next scheduled query runs... and so forth, or whether it attempts to run everything in one go.

Thanks

In reply to Andrew C

Re: Do AD-HOC reports run one after another or concurrently?

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

It runs one at a time. And there is a limit to how much time it will spend running queries each time cron runs. (Anything that has not been run will be done on the next cron run.) Code here: https://github.com/moodleou/moodle-report_customsql/blob/master/lib.php#L65

In reply to Tim Hunt

Re: Do AD-HOC reports run one after another or concurrently?

by Andrew C -

Fantastic. Definitely my favourite Moodle plugin!