Addition of indexes to enhance performance

jacob.rousseau

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.

ccollins

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?
Best
Cal
On Apr 9, 2014 10:34 AM, "jacob.rousseau"

jacob.rousseau

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