This page is for Sakai issues arising from technical or architecture design decisions that impact negatively on scaleability or performance.
Table and index structure
- - SAK-8780Getting 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
- - SAK-9860Getting 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-9862Getting issue details... STATUS : Excessive db queries generated from permissions updates in sites with provided users.