Details
-
Type:
Bug
-
Status: CLOSED
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 19.6, 20.2, 21.0, 22.0 [Tentative]
-
Fix Version/s: 19.6, 20.2, 21.0, 22.0 [Tentative]
-
Component/s: Presence
-
Labels:
-
21 Status:Verified
-
20 status:Verified
-
19 status:Verified
-
Test Plan:
Description
Presence polling causes 2 queries per every poll.
1. org.sakaiproject.component.privacy.PrivacyManagerImpl#getPrivacyByContextAndTypeAndUserIds
select privacyrec0_.id as id1_141_, privacyrec0_.contextId as contextI2_141_, privacyrec0_.lockId as lockId3_141_, privacyrec0_.recordType as recordTy4_141_, privacyrec0_.userId as userId5_141_, privacyrec0_.viewable as viewable6_141_ from SAKAI_PRIVACY_RECORD privacyrec0_ where privacyrec0_.contextId=? and privacyrec0_.recordType=? and (privacyrec0_.userId in (?))
2. And one that selects the PrivacyRecord from the results above
These can be eliminated by adding the query (1) to the query results cache and turning on 2nd level caching for the PrivacyRecord.