Page History

Performance Issues - Next Steps

    Please notify the grouper-dev mailing listas you edit this page.  Thanks!

...

Thanks all for your help!
Tom

...

Notes and Next Steps

1. GRP-7 depends on GRP-12 being completed.
2. Wiki Markup\[blair\] to work on GRP-12. Wiki Markup
3. \[blair\] to work on GRP-6. Wiki Markup
4. \[blair\] to work on GRP-10.
5. Wiki Markup\[blair\] to determine why listing a group's membership produces a separate SQL query for each membership.
6. Wiki Markup\[Duke\] to perform JNDISourceAdapter profiling or other diagnostics to identify specific perf issues.
7. Wiki Markup\[Duke\] to profile a group search to further identify where all the time is spent.
8. Wiki Markup\[Duke\] to continue their investigation into the "SQL batching" phenomenon and report their conclusions.

In addition, Duke finds the work-arounds pertaining to TAAdmins mentioned below to be reasonable for now, and will implement them at a convenient time.

Functional Issues and Associated Work Items

Wiki Markup*Browsing My Memberships or Manage Groups*
a. \ [GRP-7\] Add methods for finding child stems and groups where a Subject has the specified access or naming privileges
b. modify UI to take advantage of these
c. \ [GRP-10\] Modify Membership indices based upon recommendations from Duke

Wiki Markup*Listing group members is slow*
a. improve JNDISourceAdapter performance
b. \ [GRP-6\] API Subject caching no longer caching everything that it should
c. \ [GRP-7\] Add methods for finding child stems and groups where a Subject has the specified access or naming privileges

Wiki Markup*Ldappc performance*
a. improve JNDISourceAdapter performance
b. \ [GRP-6\] API Subject caching no longer caching everything that it should
c. \ [GRP-12\] Poor integration with Ldappc: subordinate-stem-query causes a full table scan
d. \ [GRP-13\] Poor integration with Ldappc: attribute-matching-queries causes a full table scan
e. \ [GRP-14\] Poor integration with Ldappc: Null DTO error message causes Ldappc runs to fail
f. modify Ldappc to take advantage of these
g. modify Ldappc to cache more group data

Wiki Markup*Group search*
a. \ [GRP-9\] A number of methods for retrieving groups by attribute cause full table scans.  Document methods where this is the situation and provide alternates where possible. b. modify UI to default to equality-matched & scoped  Document methods where this is the situation and provide alternates where possible.
b. modify UI to default to equality-matched & scoped searching

TAAdmins using Manage Groups
a. subclass PrepareMenuAction to omit Manage Groups for TAAdmins

...

    Questions? Contact us.

...