Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

Based on reports from the users list, we identified some performance issues with Grouper which are fixed in the latest patch.

 

This includes the performance problem of cruft in the database that should be removed (not removed by default).

 

grouper_v2_3_0_api_patch_97

 

Note, this patch took a while to be released since unit tests needed to be verified and fixed and this was time consuming.  There are more patches that are queued up which will be released shortly.  The good news is this was a needed task for Grouper 2.4.

 

For the attribute performance enhancement (GRP-1705), there is now a lot more short term caching to eliminate redundant queries.  This is on stems, groups, members (subjects not memberships), attributes, actions, and assignments.

 

These are the Jira’s:

 

GRP-1674: add daemon to trim auditing table

GRP-1694: add daemon to trim auditing table of enties with no logged in user

GRP-1701: add daemon to trim deleted point in time data

GRP-1700: delete old PIT data in batches, and not in a transaction

GRP-1658: obliterate stem endless loop if already deleted

GRP-1702: if a part of deleting old data fails from daemon, continue to the next part

GRP-1704: when deleting a group, delete any composites that is a member of

GRP-1703: add daemon to obliterate old folders based on create date

GRP-1653: do not obliterate stems in transaction by default

GRP-1705: attribute performance for built in attributes

GRP-1712: cannot delete group which has requireInGroup type

 

For deleting old data, here is a wiki.  Let me know how it goes J  I will be running this at Penn and will post here our experience.

 

https://spaces.internet2.edu/display/Grouper/Grouper+automatically+delete+old+data

 

Thanks

Chris