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!
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
-- 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.