Is your feature request related to a problem?
The evaluation cron job currently loops through each organization to check for in_progress evaluations. While this ensures all organizations are covered, the evaluation table is small enough that we could take a simpler approach.
Describe the solution you'd like
Optimize the evaluation cron job:
- Query all
in_progress evaluations directly instead of looping per organization
- Add index on
status column to speed up the query
Is your feature request related to a problem?
The evaluation cron job currently loops through each organization to check for
in_progressevaluations. While this ensures all organizations are covered, the evaluation table is small enough that we could take a simpler approach.Describe the solution you'd like
Optimize the evaluation cron job:
in_progressevaluations directly instead of looping per organizationstatuscolumn to speed up the query