FINAL_REVIEWER tsondu(བསྟན༌འཛིན༌དངོས༌གྲུབ།) saying Submit btn taking too long

[spsither]

the app is slow sometimes. Heard multiple complaints saying it's slow but seems to be irregular.

[spsither]

Reviewer Dechen from stt_tt_ga saying his Submit is also very slow. Did a check on my laptop with 29 Mbps and was quick. More info is needed.

[spsither]

added the following indexes. seems faster.

create index "Task_group_id" on "Task"(group_id);
create index "Task_state" on "Task"(state);
create index "Task_transcriber_id" on "Task"(transcriber_id);
create index "Task_reviewer_id" on "Task"(reviewer_id);
create index "Task_final_reviewer_id" on "Task"(final_reviewer_id);

List all indexes

select * from pg_indexes where tablename = 'Task';

[spsither]

After every 10th task, the user gets assigned a new set of 10 tasks. It takes longer when assigning tasks.