Issues

missing index on contentreview-item

Assignments: Submission export breaks on big data set

Assignments: Submission export breaks on big data set

Presence polling db performance improvement

sakai-rubric-student-button is making excessive http calls on load

Move Bullhorns to use Server Sent Events, rather than short polling.

MessageBundleService check cache for negative lookups

Too much time while loading gradebookNG

Create a new API that can persist grades without comments

Missing indexes for ASN_SUBMISSION

Gradebook: Gradebook performance issues in teaching assistant role

Samigo > minimize redundant UPDATE queries on SAM_ITEMGRADING_T

Add parameter to getDeletedResources to specify age

Cache the results of getAliases(String)

Performance cache calls to getAuthzUserGroupIds

Limit the concurrent sessions of a single user.

Option to send and retrieve events (via cluster mechanism) without going to the database

Virus scanning can be slow, need to queue scans in a thread and periodically scan to avoid making the user wait and hold up threads

getAll/Complete cache: NotificationCache m_cache, BaseNotificationService

Sakai getAll caching is dangerous and cannot be supported by the Java cache standard (JSR-107)

excessive memory usage inside realmRoleGroupCache values

refreshAuthzGroup is inefficient and can cause high load

SiteCacheImpl is incompatible with distributed/JSR-107 caching

Unsatisfiable partial-content requests not handled correctly

getUsersIsAllowed in a large sites can result in terrible MySQL query performance

User caching happens in threadlocal as well as cache

Tool attached files cannot be read by users who do not have site content.read permission

Bypass isDropboxOwnerInCurrentUserGroups if user is maintainer

org.sakaiproject.util.Blob should be deprecated(removed) as holding large byte arrays in memory is almost always unnecessary

BaseContentService uses Map for caching

BasePreferences are "cached" in MySession and Ehcache

Checks for explicit locks are unnecessary for ContentCollections

CacheRefresher no longer working for any cases (though it could work for MRC)

Performance issues in Admin user search

Unnecessary query for every content access

Rewrite MemoryService APIs to allow pluggable caching (JSR-107)

Queries for permission checks are slow in large sites

SiteService.getUserSites should have way to pre-filter sites (Sites drawer slow with lots of sites)

Performance issues in site visits and retrieval (doSite, getSites)

Performance issues with message bundles loading and java.lang.IllegalStateException: Timer already cancelled. error

Samigo > improve performance when copying questions from pool to quiz

Joining the bigint pageId on the string sakaiId can be very bad on MySQL

Ineffective caches should be removed

NPE in ShowPageProducer

Scores page load times excessive for large sites with assessments released to groups.

Calls to ExternalAssement provider are expensive

update SAM_ITEMGRADING_T multiplies as user progresses through long assessment

Import Quiz XML/ZIP slow

POJO'ise assesment objects

Quiz delivery generates excessive queries