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 2 Next »

This page is for Sakai issues arising from technical or architecture design decisions that impact negatively on scaleability or performance.

SQL Optimization

Table and index structure

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

Volume of database queries

  • T Key Summary Assignee Reporter P Status Resolution Created Updated Due

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