Item Analysis page load times excessive for large and how to find queries.

Since it's been over two years without any further information provided, we're closing this Jira issue for now. If more details become available in the future, we can reopen it. Thank you.

Is this issue still occurring, and if so, could we please have screen shots and the information that was requesting before?

Could some testing steps be added please? I assume this requires a huge class with many submissions to a test?

Could lazy loading be applied to the page to improve performance?

Please use Yourkit and attach a report based on the page load.

I believe this page is the
samigo-app/src/webapp/jsf/evaluation/detailedStatistics.jsp

It's generating this table from samigo-app/src/java/org/sakaiproject/tool/assessment/ui/bean/evaluation/HistogramScoresBean.java
<dataTable value="#{histogramScores.detailedStatistics}

But this is set by the histogramScores method in the Listener samigo-app/src/java/org/sakaiproject/tool/assessment/ui/listener/evaluation/HistogramListener.java

This looks complex to me, it's all run each time this page is accessed and none of it is cached. Sakai wasn't designed to have thousands of users in a single course, so there's a lot of work to make this use case work in Samigo. To improve the performance of this you'd really have to take some of this code out and compute it in something like a quartz job. It looks like it goes through all of the scores and creates a lot of statistics.

It sounds like there was a discussion on the dev list https://groups.google.com/a/apereo.org/forum/#!msg/sakai-dev/6l2h8Wu2SlE/mlqcmhUGBwAJ