User subject assignment and unassignment slow

[mahalakshme]

https://avni.freshdesk.com/a/tickets/3263

Issue:

Assignment and unassignment of individuals to users, taking around 20 secs.

Without understading this, the user tries to click the checkbox to assign repeatedly and faces 'Constraint Violation' issues.

Analysis:

Looks like as part of this card, this slowness issue has got introduced. Before when there was just assigning to groups I don't remember seeing this slowness issue.

Acceptance criteria:

The assignment and unassignment should take less than one sec ideally. Optimise how muchever possible.

[petmongrels]

-- https://explain.dalibo.com/plan/73bcg1a3fbfhf32a (before)
-- https://explain.dalibo.com/plan/d913798b9e2g029h (after)

[petmongrels]

QA

• can be tested on pre-release by deploying 7.0 (merged the change to 7.0), we don't have env for 6.1 to test
• post QA need to tag and deploy to prod

[AchalaBelokar]

and also not able to assign to the user

Screen.Recording.2024-02-08.at.1.48.39.PM.mov

• @petmongrels I am not able to unassign user .
  https://app.circleci.com/pipelines/github/avniproject/avni-webapp/2275/workflows/4d5ad204-c7c9-4624-8cc7-788518a811e0/jobs/7457. Deployed on prerelease

[mahalakshme]

@achala did you test sync functionality with direct assignment as well?