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
- GRP-7 depends on GRP-12 being completed.
\[blair\] to work on GRP-12.Wiki Markup Wiki Markup - \[blair\] to work on GRP-6.
Wiki Markup - \[blair\] to work on GRP-10.
\[blair\] to determine why listing a group's membership produces a separate SQL query for each membership.Wiki Markup \[Duke\] to perform JNDISourceAdapter profiling or other diagnostics to identify specific perf issues.Wiki Markup \[Duke\] to profile a group search to further identify where all the time is spent.Wiki Markup \[Duke\] to continue their investigation into the "SQL batching" phenomenon and report their conclusions.Wiki Markup
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
*Browsing My Memberships or Manage Groups*
Wiki Markup
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
*Listing group members is slow*
Wiki Markup
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
*Ldappc performance*
Wiki Markup
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
*Group search*
Wiki Markup
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.
...