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

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

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?)
  • Assignments
  • Resources / Content Hosting
  • Gradebook (mostly resolved in 2.5?)

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.

Completed issues

  • 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.
  • No labels