REDCap Customisation Cron History Indexes

Tags: REDCap Customisation_Category

I noticed that the briccsDbDev was running at 100% CPU. The cause was that the REDCap cron job was checking cron history every minute and the history table was massive and there weren't appropriate indexes. So I created those indexes in both live, test and external:

CREATE INDEX redcap_crons_history_cron_id_cron_run_status ON redcap_crons_history (cron_id, cron_run_status);
CREATE INDEX redcap_crons_history_cron_id_cron_run_start ON redcap_crons_history (cron_id, cron_run_start);

Error: Macro BackLinks(None) failed

'Environment' object has no attribute 'get_db_cnx'