Child pages
  • Scalability and performance watchlist
Skip to end of metadata
Go to start of metadata

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 - Evaluate Forums Performance from a "site with a large number of groups" perspective ( Closed)

Messages

  • Scalability issues sending messages in sites with large membership SAK-14626 - Serious scalability issue with Messages tool ( Closed) , SAK-14392 - When sending by email messages should use bulk sending ( Closed)

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 - Stuck threads use excessive CPU ( Resolved)

SQL Optimization

Table and index structure

Slow DB queries

  • KNL-1068 - Queries for permission checks are slow in large sites ( Closed) : Permissions checks slow in sites with large membership

Volume of database queries

  • SAK-9862 - Excessive db queries from permissions change in sites with provided users ( Awaiting Review) : 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) ( Closed) : Reduce number of CM queries required when user logs in (hibernate impl)

Completed issues

  • SAK-8932 - Runaway CPU use on app server ( Closed) : Chat "stuck threads"
  • SAK-11636 - HTTP Basic operations create a login event for each request and refreshes authzgroups. ( Closed) : HTTP Basic operations create a login event for each request and refreshes authzgroups
  • SAK-9860 - Excessive db queries generated from Site Info / user service ( Closed) : 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 ( Closed) : Excessive db queries for dropbox on site update actions
  • SAK-10021 - DropBox Performance Problems ( Closed) : Dropbox Performance Problems
  • SAK-8780 - Poor performance finding open sessions on MySQL and Oracle ( Closed) : 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 - Email archive viewing performance degrades with number of messages ( Closed) , SAK-11544 - Improve performance of existing Mail Archive Tool ( Closed) : Performance degrades with a large number of messages
  • SAK-13021 - Overview page generates too many queries leading to performance issues ( Closed) : Section Info: Overview page generates too many queries leading to performance issues
  • SAK-13312 - Improve Group performance -- especially Site.getGroupsWithMember() method ( Closed) : Improve Group performance
  • No labels