-
Bug
-
Resolution: Fixed
-
High
-
2.8, 2.9.1
-
None
Crowd 2.8's /rest/usermanagement/1/group/membership is significantly slower than earlier versions of Crowd, 2.7 and 2.6 . Here is an example between Crowd 2.6.5 and Crowd 2.8.0 with 50000 users, and 1000 groups, and 1000000+ group memberships (this is with flat group memberships only. The problem is compounded with Nested Group memberships):
- Crowd 2.6.5 took 56s to load /rest/usermanagement/1/group/membership
wget --user crowdperformance --password admin http://localhost:8265/crowd/rest/usermanagement/1/group/membership --2015-05-06 18:24:19-- http://localhost:8265/crowd/rest/usermanagement/1/group/membership Resolving localhost... 127.0.0.1, ::1 Connecting to localhost|127.0.0.1|:8265... connected. HTTP request sent, awaiting response... 401 Unauthorized Connecting to localhost|127.0.0.1|:8265... connected. HTTP request sent, awaiting response... 200 OK Length: unspecified [application/xml] Saving to: `membership.1' [ <=> ] 29,348,141 585K/s in 56s
- Crowd 2.8.0 took around 8 mins to load /rest/usermanagement/1/group/membership:
wget --user crowdperformance --password admin http://localhost:8280/crowd/rest/usermanagement/1/group/membership --2015-05-06 18:15:32-- http://localhost:8280/crowd/rest/usermanagement/1/group/membership Resolving localhost... 127.0.0.1, ::1 Connecting to localhost|127.0.0.1|:8280... connected. HTTP request sent, awaiting response... 401 Unauthorized Connecting to localhost|127.0.0.1|:8280... connected. HTTP request sent, awaiting response... 200 OK Length: unspecified [application/xml] Saving to: `membership' [ <=> ] 29,348,141 175K/s in 8m 2s
Both queries return the exact same XML output
Note
This is tested with the same exact user base (via CSV import). It is especially evident with a high user-base .
- incorporates
-
CWD-3809 ApplicationServiceGeneric#searchNestedGroupRelationships performs n+1 queries in order to shadow users
-
- Closed
-
- is blocked by
-
CONFSERVER-44221 Slow user synchronisation from Crowd directory
-
- Closed
-
- is related to
-
CONFSERVER-45698 Confluence 5.9+ much slower to sync users and remove users from groups compared to 5.8
-
- Closed
-
-
CWD-4484 spring-ldap:2.x causes slow search queries
-
- Closed
-
- mentioned in
-
Page Failed to load
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
[CWD-4344] Significantly Slower Sync to Confluence or JIRA in Crowd 2.8 due to /rest/usermanagement/1/group/membership
Remote Link | Original: This issue links to "Page (Extranet)" [ 121917 ] |
Remote Link | Original: This issue links to "Page (Extranet)" [ 133857 ] |
Workflow | Original: Simplified Crowd Development Workflow v2 - restricted [ 1511233 ] | New: JAC Bug Workflow v3 [ 3365724 ] |
Affects Version/s | New: 2.9.1 [ 46094 ] |
Link | New: This issue is blocked by CONFCLOUD-44221 [ CONFCLOUD-44221 ] |
Remote Link | New: This issue links to "Page (Extranet)" [ 259544 ] |
Link |
New:
This issue is related to |
Remote Link | Original: This issue links to "Page (Extranet)" [ 109890 ] |
Remote Link | New: This issue links to "Page (Extranet)" [ 223872 ] |
Remote Link | New: This issue links to "Page (Extranet)" [ 223104 ] |