We are running Opinio Enterprise 6.0.8 with Oracle 10G on the backend and are having intermittent performance problems on the database side. When we do, we see high numbers of connection which appear to be running the following query: "DELETE FROM ops_reportrespondent". What initiates these queries? Has anyone else ran into this situation? Any help would be much appreciated. Thanks, Michael
This is related to report filters. If you have high-load surveys, you should create your reports containing filters after respondents have completed the survey. This is because Opinio updates report filters as respondents answer the surveys.
We will look into this, and possibly find ways to optimize. Perhaps by recalculate filters before viewing the report (this would slow down creation of the reports, however).