click here for details... Sakai Executive Director Position Search now open
Issue Details (XML | Word | Printable)

Key: SAK-5288
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Zhen Qian
Reporter: Zhen Qian
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Sakai

too many db access for getting preferences

Created: 21-Jun-2006 12:56   Updated: 23-Oct-2008 11:15
Component/s: Global
Affects Version/s: 2.2.0
Fix Version/s: 2.2.0

Time Tracking:
Not Specified

Issue Links:
Depend
 

2.6.x Status: None
2.5.x Status: None
2.4.x Status: None


 Description  « Hide
As can be seem from the log file, there are too many calls for "select xml from sakai_preferences". Solution is to use session variable to cache the current user preferences, and only query db if there is a cache miss.

However, for those queries in some thread that NOT in the user's session, the above approach won't help.

- Zhen

 All   Comments   Work Log   Change History   Subversion Commits   git Commits      Sort Order: Ascending order - Click to sort in descending order
Stephen Marquard added a comment - 23-Jun-2006 07:29
Testing with 2.2.0_006, this change has eliminated all the redundant queries to SAKAI_PREFERENCES when viewing the assignment list.

Megan May added a comment - 28-Jul-2006 06:25
This should have been in 2.2.0. Also, it looks like Stephen was able to test it.