Difference between the Tuned Large and Tuned Small settings for the SYS Full Refresh Algorithm reports switch

The switch SYS Full Refresh Algorithm is only present in Oracle.

This is used during Full Refresh of the dm_cached_form_ans table and has two possible values:

If set to Tuned Large, Short text answers and Long text answers are loaded into dm_cached_form_ans using a concept of Bulk Collect, meaning the data is committed after inserting every 1000 rows in a loop. Numeric, Boolean, Date answers are loaded and committed in the end once for each of the answer type.

If set to Tuned Small, Short text answers, Long text answers, Numeric, Boolean, Date answers are loaded and committed in the once for each of the answer type.