Skip to content

Improve performance of course_cron by including only private fulfillments.

puddyglum requested to merge issue/course-3028228:3028228-cron-hook-times into 7.x-2.x

Closes #3028228

Our use case returned 1M+ object fulfillments, and the query itself took over 2 min. Cron would run out of memory even when memory limit set to 2G. Most object fulfillments were not private. Adding where condition of data LIKE '%"private";b:1%' is not ideal, but seems safe and effective. Our cron runs in under one second now.

Merge request reports