Hundreds of unnecessary requests during load of gradebook

Asked by Peter Dracvel

Hello,

Finally I discovered why schooltool is sooo slow when reading gradebook (in my case it depends on high number of pupils in class).
It's because every read of gradebook generates a 2xnumber of pupils requests to apache proxy and then to zope/schooltool. In my case it generates over 1300 req/s! That's pretty high number even with today hardware for apache and especially zope/schooltool. What's more these requests are unnecessary, there are static nod modified jsons, ie:

https://192.168.0.5/schoolyears/2016/2016/sections/1/activities/Worksheet/gradebook/student_popup_menu?student_id=...

generates:

{"header": "----personal info cut----", "options": [{"url": "https:\/\/192.168.0.5\/persons\/----personal info cut----", "label": "Pupil"}, {"url": "https:\/\/192.168.0.5\/schoolyears\/2016\/2016\/sections\/1\/activities\/Worksheet\/gradebook\/----personal info cut----", "label": "Score"}, {"url": "https:\/\/192.168.0.5\/schoolyears\/2016\/2016\/sections\/1\/activities\/Worksheet\/gradebook\/----personal info cut----\/history.html", "label": "Score History"}, {"url": "https:\/\/192.168.0.5\/schoolyears\/2016\/2016\/sections\/1\/activities\/Worksheet\/gradebook\/----personal info cut----\/view.html", "label": "Report"}]}

I would understand if it need to read the score with every request, but this is done reading the whole gradebook (6 seconds). Rest 1-2 minutes is spending on those request for jsons.

As I read the schooltool isn't anymore maintained by developers (what's a pity because of very good software), so I'll try with modyfy http headers (Pragma and cache-control) to cache those GET json requests in browser cache mem and also configure cache in apache, it's all I can do for now. I will give the resolution on request if someone has the same problem.

I don't know why but firefox shows that gradebook has loaded in 6 seconds, even when it still for 1-2 minutes. Only chrome today shows me the hidden true about the speed of page loading. I should be more clever to test if something wrong in the other browsers too in the future.

However if the schooltool will be mainteind again just remember to optimize this behaviour and implement in the next release, I think that schooltool will speed up a lot. (I bet that even more than 50%)

Question information

Language:
English Edit question
Status:
Expired
For:
SchoolTool Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Launchpad Janitor (janitor) said :
#1

This question was expired because it remained in the 'Open' state without activity for the last 15 days.