This page is for Sakai issues arising from technical or architecture design decisions that impact negatively on scaleability or performance.
Slow tools
Forums
Mostly resolved in 2.5, though still shows slow performance for:
- very large topics (say 500+ messages)
- synoptic tool in my workspace
- sites with a large number of groups SAK-11798
Messages
Assignments
(resolved in 2.5)
Resources / Content Hosting
(improved in 2.5)
Gradebook
(mostly resolved in 2.5?)
Email Archive
(resolved in 2-5-x)
Tools / services which affect app server stability and performance
JSF "stuck threads" issue:
SQL Optimization
Table and index structure
Slow DB queries
- SAK-10193: Permissions checks slow in sites with large membership
Volume of database queries
- SAK-11636: HTTP Basic operations create a login event for each request and refreshes authzgroups
- SAK-9862: Excessive db queries generated from permissions updates in sites with provided users.
- SAK-10859: Reduce number of CM queries required when user logs in (hibernate impl)
Completed issues
SAK-9860: Excessive db queries generated from Site Info / user service. Site Info generates 5 db queries for every site member (1 to SAKAI_USER and 4 to SAKAI_USER_ID_MAP).
SAK-9887: Excessive db queries for dropbox on site update actions
SAK-10021: Dropbox Performance Problems
SAK-8780: The table structure of SAKAI_SESSION forces the db (at least mysql) to do a full table scan to find out which sessions are currently open.
SAK-13021: Section Info: Overview page generates too many queries leading to performance issues
SAK-13312: Improve Group performance