Very slow navigation when working with question pools
Description
is related to
Activity
Sam Ottenhoff August 28, 2015 at 10:21 AM
I would avoid trying to selectively pull these changes without lots of testing. The database change is an important change.
Bill Niebel August 28, 2015 at 10:19 AM
We're running locally-built 10.2 at UVa and reviewed post-10.2 global Jira issues and selected some to patch in, among them. Are the other subtasks independent of subtask SAM-2259? I'm asking this to verify that we can apply the other subtasks without a database downtime and simply postpone applying subtask until our next general upgrade which has a planned database downtime.
I see that all subtasks have either SVN merges or an attached patch. But I also found that main issue has a github link
https://github.com/sakaiproject/sakai/commit/7f11179578328c3ac5f3ab68e843829db22780c5
whose change doesn't seem to have been merged into SVN. I don't understand the status of that github commit, but like subtask it also seems independent of the other subtask changes. Do I have that right? (I hope so, as we've already applied that github patch.)
Thanks for clarifying.
Matthew Buckett January 5, 2015 at 10:43 AM
Merged pull request.
Sam Ottenhoff January 2, 2015 at 4:32 PM
Pull request here: https://github.com/sakaiproject/sakai/pull/10
Sam Ottenhoff December 12, 2013 at 11:50 AM
I believe this is also related to calculations of question pool size..... I believe the code is effectively loading every single question pool belonging to the user, then loading every question to calculate the QP pool size.... seems like an easy place for some optimization.
Intermittent navigation slowdowns when using question pools, both when first accessing pools (for example, approx 20 seconds for "question pool" page to display after clicking "question pool" in the menu bar) and when navigating among different pools and subpools.
We confirmed slowdowns for users with questions pools containing 60-200 questions. The slowdowns are occurring in unpublished sites that have no or small rosters, and also occur while attempting to add multiple subpools that don't yet contain any questions.