= REDCap Customisation Cron History Indexes

Tags: [[REDCap]] [[Customisation_Category]]

I noticed that the briccsDbDev was running at 100% CPU.  The cause was that the test 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:

{{{
#!sql

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);

}}}

[[BackLinks]]