Scalability and performance watchlist

Owned by Former user (Deleted)
Last updated: Aug 26, 2009Version comment
1 min read

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 - Getting issue details... STATUS

Messages

  • Scalability issues sending messages in sites with large membership SAK-14626 - Getting issue details... STATUS , SAK-14392 - Getting issue details... STATUS

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:

  • Tests and Quizzes: SAK-11098 - Getting issue details... STATUS

SQL Optimization

Table and index structure

Slow DB queries

  • SAK-10193 - Getting issue details... STATUS : Permissions checks slow in sites with large membership

Volume of database queries

  • SAK-9862 - Getting issue details... STATUS : Excessive db queries generated from permissions updates in sites with provided users.
  • SAK-10859 - Getting issue details... STATUS : Reduce number of CM queries required when user logs in (hibernate impl)

Completed issues

  • SAK-8932 - Getting issue details... STATUS : Chat "stuck threads"
  • SAK-11636 - Getting issue details... STATUS : HTTP Basic operations create a login event for each request and refreshes authzgroups
  • SAK-9860 - Getting issue details... STATUS : 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 - Getting issue details... STATUS : Excessive db queries for dropbox on site update actions
  • SAK-10021 - Getting issue details... STATUS : Dropbox Performance Problems
  • SAK-8780 - Getting issue details... STATUS : 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-5943 - Getting issue details... STATUS , SAK-11544 - Getting issue details... STATUS : Performance degrades with a large number of messages
  • SAK-13021 - Getting issue details... STATUS : Section Info: Overview page generates too many queries leading to performance issues
  • SAK-13312 - Getting issue details... STATUS : Improve Group performance