We are currently working on the forum. For the short-term, all forum content will be in read-only format. We apologize for the interruption and look forward to collaborating with you shortly. All the best in your research!

Addition of indexes to enhance performance

jacob.rousseaujacob.rousseau Posts: 22 ✭✭
edited April 2014 via Email in Study Build, Rules, and CRFs
Dear group, To decrease the duration of saving CRF's we at CTMM-TraIT have found a number of missing indexes in the OpenClinica datamodel. For example after adding the indexes the duration of saving a CRF with a lot of dynamic items decreased from approx. 45 seconds to approx. 5 seconds. More details can be found in the OpenClinica call http://jira.openclinica.com/browse/OC-5087 . If you experience performance issues, then you could apply the script to your DB now. Before applying it to a production instance, please do first test this extensively on a backup copy of your DB! Regards, Jacob Jacob Rousseau CTMM - TraIT / VU University Medical Center Dept. of Medical Oncology (Room 3A35) De Boelelaan 1117 1081 HV Amsterdam Mob: +31 (0)6-22442292 Tel: +31 (0)20-4443257 Fax:+31 (0)20-4444970 -- =============================================================================== -- -- Test script to add indices on the dyn_item_form_metadata mapping and other tables to -- hopefully improve performance for the XXXXX and (probably) XXXXX studies.
Post edited by bbaumann on


  • ccollinsccollins Posts: 383 admin
    via Email
    Thanks Jacob, sounds exciting! What do you mean by a CRF with a lot of
    dynamic items? Are you referring to repeating groups, to hidden items, or
    something else?
    On Apr 9, 2014 10:34 AM, "jacob.rousseau"
  • jacob.rousseaujacob.rousseau Posts: 22 ✭✭
    Hallo Cal,
    The 'dynamic' term was used in the table names (e.g. dyn_item_group_metadata), it means that items in a CRF can be shown and hidden. In the dyn_item_group_metadata and
    dyn_item_form_metadata there is a field which controles the visiblity of items. I've added some more information in the JIRA

    greetings, Jacob
This discussion has been closed.