[Building Sakai] Slow hibernate call

[Paul Dagnall]

Hi
I'm working on a Samigo custom and have come upon a bit of a performance
issue.

I call publishedAssessmentService.getPublishedAssessment(string).
Eventually this method calls...

List sectionList = getHibernateTemplate().find(
                "from PublishedSectionData s where
s.assessment.publishedAssessmentId=? ",
                assessment.getPublishedAssessmentId());

This hibernate call is taking up to 5 seconds to execute. The query:

select * from SAM_PUBLISHEDSECTION_T where ASSESSMENTID = 478438

... will return results immediately.

Any ideas?

Paul Dagnall
Application Developer & Administrator
University of Dayton
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140702/9e2332b6/attachment.html