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