Search option is taking a more time and time consuming

[AchalaBelokar]

Describe the bug
Search option is taking a more time and time consuming
I Login to himeshr@jsscp and try to serach a individual or pulwari.
but after clicking on search button it takes the 15 sec on 9.0
also I am trying to add child in phulwari it is taking a time.

To Reproduce
Steps to reproduce the behavior:

1. Login to himeshr@jsscp
2. click on search(search in mydashboard and search to add a member(here it crashes))
3. after that it will take a time

Additional details

• db uploaded
• some memory error can be seen in the logs
• checked in different mobiles and doesn't seem to be a device specific issue

Expected behavior
result should be shown less than 15 sec
Screenshots

this recording is 8.0
https://github.com/avniproject/avni-client/assets/104890488/e6d6d5ee-0af2-481b-8402-2831830d92a8

this recording is on 9.0
https://drive.google.com/file/d/1ndbfsFBJ6k_2SBsVepZdJKuHVZIT-9Go/view?usp=drive_link
name with performance issue 1440

Desktop (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Smartphone (please complete the following information):

• Device: [e.g. iPhone6]
• OS: [e.g. iOS8.1]
• Browser [e.g. stock browser, safari]
• Version [e.g. 22]

Additional context
Add any other context about the problem here.

Developer Checklist
Developer fixing the bug should fill this checklist.

• Does the fix require extensive regression testing?
• Are you mentioning the required scenarios that could be affected?

[mahalakshme]

@himeshr I ve added additional details in the card.

@vinayvenu the card was in 'New issues' since was waiting for some details from achala.

[himeshr]

@AchalaBelokar Please confirm the following details..
I suspect that the 8.0 version is run using Production env apk, whereas 9.0 is run using Prerelease env apk.
Due to the difference in environments for jsscp org, there is difference in Search Result filters configured, as seen in below screenshot.

The cause for app to break in prerelease is not due to any code change, but due to the extra configuration of SearchFilter of type "Group Subject".

This is a problem that would not necessarily be a blocker for 9.0 release and might need more analysis on whether it can be fixed at all, due to the large volume of data that is present for that User's Catchment.

[mahalakshme]

with less data not happening in 9.0. JSSCP permissions in prerelease is incorrect. So we might not have so much data in JSSCP. - need to check with big catchments like in CK and compare 8.1 and 9.0 to identify if performance has really degraded @AchalaBelokar

[mahalakshme]

@AchalaBelokar moving this to done since I guess u tested it