Grouper Developers Forum

[Chris Hyzer <>]

I added these DB views:

 

https://bugs.internet2.edu/jira/browse/GRP-423

https://bugs.internet2.edu/jira/browse/GRP-385

 

grouper_change_log_entry_v
with the following columns:

"created_on", "change_log_category", "action_name", "sequence_number",
             "label_string01", "string01", "label_string02", "string02",
             "label_string03", "string03", "label_string04", "string04",
             "label_string05", "string05", "label_string06", "string06",
             "label_string07", "string07", "label_string08", "string08",
             "label_string09", "string09", "label_string10", "string10",
             "label_string11", "string11", "label_string12", "string12",
             "context_id", "change_log_type_id"

This makes the change log easier for a human to read.

 

 

There are three new views with the same columns as the previous three lightweight membership views:

 

grouper_mship_attr_flat_lw_v

grouper_mship_group_flat_lw_v

grouper_mship_stem_flat_lw_v

 

These are on the flattened tables.  If you are seeing if a user is in a group or listing the members of a group or the groups of a user, then flat and nonflat have similar performance (at least a similar cost in oracle explain plan).  However, if you do heavier things then the flat tables have much better performance.

 

e.g. select all memberships: SELECT * FROM grouper_memberships_lw_v

 

nonflat cost: 60,000

flat cost: 6,000

 

e.g. select all memberships that someone is allowed to read

 

SELECT mships.*

  FROM grouper_memberships_lw_v mships, grouper_memberships_lw_v privs

 WHERE mships.GROUP_ID = privs.GROUP_ID

   AND mships.list_name = 'members'

   AND privs.list_name IN ('readers', 'admins')

   AND privs.subject_source = 'abc'

   AND privs.subject_id = 'def';

 

nonflat cost: 16,000

flat cost: 52

 

Bottom line if you are doing complex operations, and you can deal with a few minutes of propagation delay, then the flat views will be a more performant way to get your data...