Skip to Content.
Sympa Menu

grouper-dev - RE: [grouper-dev] Re: GRP-146

Subject: Grouper Developers Forum

List archive

RE: [grouper-dev] Re: GRP-146


Chronological Thread 
  • From: "GW Brown, Information Systems and Computing" <>
  • To: Chris Hyzer <>, Tom Barton <>,
  • Subject: RE: [grouper-dev] Re: GRP-146
  • Date: Wed, 03 Sep 2008 09:18:37 +0100

--On 02 September 2008 15:01 -0400 Chris Hyzer <> wrote:

This tangential idea isn't for 1.4, but long term... I mentioned this
before...

If we are going to have hibernate optimistic locking on (which prevents
multiple users overwriting each others changes), then it would be nice if
changing membership information doesn't update the group's last modified
date (only editing the group or perhaps attributes should do that).
Think long term we could have a membership (or whatever else ancillary)
column for last modified, and ldappc or other provisioners can use each
of these instead of one monolithic queue? I think performance of regular
grouper operations would improve also since there would be fewer
queries...
I'm pretty sure blair found that - some performance gains went by the by when he realised that the group modify time was not being updated and he then fixed it.

Thanks,
Chris

-----Original Message-----
From: Tom Barton
[mailto:]
Sent: Tuesday, September 02, 2008 2:56 PM
To:

Subject: Re: [grouper-dev] Re: GRP-146

Good.

Chris Hyzer wrote:
> Ok, that makes sense. I see only GroupModifiedAfter used in ldappc,
so I removed group_modified_time_idx from my list of recommended ones
to remove... sound good?
>
> Thanks!
> Chris
>
>> -----Original Message-----
>> From: Tom Barton
[mailto:]
>> Sent: Tuesday, September 02, 2008 2:44 PM
>> To:

>> Subject: Re: [grouper-dev] Re: GRP-146
>>
>> These filters are used by Ldappc, I think.
>>
>> Chris Hyzer wrote:
>>> The filters would use the indexes. I see these filters available:
>>>
>>> GroupCreatedAfter
>>> GroupCreatedBefore
>>> GroupModifiedAfter
>>> GroupModifiedBefore
>>>
>>> StemCreatedAfter
>>> StemCreatedBefore
>>>
>>> Just curious, where are these filters used? Or what would a use
>>> case
>> be?
>>> I could see the created_by and modified_by being used when changing
>> someone's member_id (jira issue open for this), though I think that
>> is such a seldom used feature it might not require an index...
>>> Thanks,
>>> Chris
>>>
>>>
>>>> -----Original Message-----
>>>> From: Tom Barton
[mailto:]
>>>> Sent: Tuesday, September 02, 2008 12:50 PM
>>>> To:

>>>> Subject: [grouper-dev] Re: GRP-146
>>>>
>>>> Emily Eisbruch wrote:
>>>>> [A1] {Group} will review and provide thoughts on GRP 146.
>>>>> https://bugs.internet2.edu/jira/browse/GRP-146
>>>> Regarding the suggestions for the grouper_groups table
>>>>
>>>> - drop: group_createtime_idx
>>>> - drop: group_creator_idx
>>>> - drop: group_modifier_idx
>>>> - drop: group_modify_time_idx
>>>>
>>>> do we need to maintain group_createtime_idx and/or
>>>> group_modify_time_idx to support corresponding GrouperQuery
filters?
>>>> Similar question for grouper_stems.
>>>>
>>>> Tom
>>>>
>




----------------------
GW Brown, Information Systems and Computing




Archive powered by MHonArc 2.6.16.

Top of Page