Fix Select N+1 problem with User Role Assignments

Description

Perf test is typically falling in the 40s range to load a single user with many role assignments.

Environment

None

relates to

QAlity Plus - Test Management

Checklists

Activity

Show:

Josh Zamor 
September 19, 2017 at 4:25 PM

This looks good to me, and the Reviews are I believe done done. I don't think this is directly QA-able, so moving to Done.

Brandon Bowersox-Johnson 
September 11, 2017 at 10:27 PM

I have estimated this as a 5. With lots of files touched (~6) and 3 different reviews, this seems significant. Feel free to change estimate if 5 is inaccurate.

Chongsun Ahn 
September 9, 2017 at 5:29 PM

Local results in profiler showed a change from 500 milliseconds to 5-10 milliseconds for getting a user. Recent CI build on performance test server shows a change from 38 seconds to about 200 milliseconds http://build.openlmis.org/job/OpenLMIS-referencedata-performance/310/performance/.

Brandon Bowersox-Johnson 
September 5, 2017 at 5:49 PM

This is a ticket in the sprint that we had mentioned you doing (during grooming).

Done
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Story Points

Components

Sprint

Fix versions

Affects versions

Priority

Time Assistant

Created August 31, 2017 at 8:22 PM
Updated November 16, 2017 at 6:46 AM
Resolved September 19, 2017 at 4:26 PM