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