use the faster acs_users_all view rather than cc_users to get submitter (it's the right view anyway since you don't care about the current users membership state etc)
check constraints before starting assessment; check time constraints when submitting responses; added ip_mask to as_assessments; added indexes to speed up datamodel