Changes between Version 1 and Version 2 of REDCap Customisation Cron History Indexes


Ignore:
Timestamp:
01/09/16 10:53:01 (9 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • REDCap Customisation Cron History Indexes

    v1 v2  
    33Tags: [[REDCap]] [[Customisation_Category]]
    44
    5 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:
     5I 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:
    66
    77{{{