Improve performance of course_cron by including only private fulfillments.

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.

Tests pass locally for me. Appears UUID 7.x-1.3 is creating test issues. Patch for this issue is RTBC: https://www.drupal.org/project/uuid/issues/3061669#comment-13283150

@devin It's awkward to filter on serialized data, but I'm not sure there is any other way to filter the query itself.

added 3 commits

• 2578a99f...7e86369c - 2 commits from branch project:7.x-2.x
• 1bd3cbca - Improve performance of course_cron by including only private fulfillments.

Compare with previous version

added 11 commits

• 1bd3cbca...144b2cc3 - 10 commits from branch project:7.x-2.x
• db30e89b - Improve performance of course_cron by including only private fulfillments.

Compare with previous version

approved this merge request