[DEA] search

[mahalakshme]

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

Need:

The below are messages from the user gathered via whatsapp:

• User says he is unable to do most of his work because of timeout errors during DEA search by concept.
• User says he was not facing this timeout errors before
• also repeated issues related to address search raised by another user.

Issue:

Search by concept value resulting in timeout error in prod

• in JSCS when selected SS, resulted in timeout
• in Shelter took around 2 mins for Household no

AC:

• After deploying 10.1.0, in JSCS on selecting SS - it took 1-2 mins instead of timeout on prerelease
• so cherrypick this and fix here - to 10.0.4 - after making sure it is applicable for the above usecase. Else let know in the comments section.
• Also revert the deployment of 10.1.0 in the prerelease, so that above testing can be done.

Old: Ignore

• Search by anything in Data Entry App should not take more than 5 secs - search by concept filters, Search All, name, DOB, Address, Registration date filters, etc.,
• Validate the same using gatling performance setup since seems like the issue is raised now repeatedly and also to make sure regression issues doesn't arise with respect to performance from our end.
• Please note the release no

Technical suggestion:

• After deploying fix here, in JSCS on selecting SS - it took 1-2 mins instead of timeout - so might help
• Also find more ways - GIN index for observations are used? etc.,
• Displaying count cant be removed since users find it useful

[himeshr]

Prev release deploys and DEA Search analysis results for JSCS org:

• 9.4 release

• • SCS - SS filtered search => success, 2 minutes (cold and hot)
• • JSCS search without filters => success, 20-30 seconds (cold and hot)

• 10.0_hotfix_2 release

• • SCS - SS filtered search => success, 2.4 minutes (cold and hot)
• • JSCS search without filters => success, 2-25 seconds (cold and hot)

• 10.0.4 release (After this fix)

• • SCS - SS filtered search => success, 45 seconds - 1.5 minutes (cold and hot)
• • JSCS search without filters => success, 01-30 seconds (cold and hot)