Improve performance of Subject list on New Experiment page at scale

Description

From the top bar UI, users can launch the process to create a new experiment from New > Experiment. After selecting a project, the project’s subject list needs to be queried to allow the user to select a subject. In some larger internal servers, we’ve seen this loading take 9 seconds. We’d like to trim that down to a more responsive time.

Environment

None

Acceptance Criteria

None

Summary of Technical Changes

None

QA Notes

None

Attachments

1
  • 07 Jul 2023, 04:19 PM
100% Done
Loading...

Activity

Show:

Charlie Moore August 1, 2023 at 4:30 PM

I was having trouble noticing a significant difference on my existing dev stack, so I got the database pointed at Bin’s “hulk” server, and looked at the time reported in the browser for the subject call for a specific project. These are the times from 3 runs, for both 1.8.8.2 and 1.8.9-SNAPSHOT:

1.8.8.2:
14.36 s
12.14 s
12.32 s

1.8.9-SNAPSHOT:
2.52 s
1.61 s
1.47 s

Looks like a great performance boost to me . Thanks, Tim!

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

Details

Assignee

Reporter

Labels

Product Team

Core

Start date

Time remaining

0h

Sprint

Fix versions

Due date

Priority

Zendesk Support

Clockify

Created January 10, 2023 at 8:23 PM
Updated October 11, 2023 at 2:54 PM
Resolved May 17, 2023 at 3:17 PM