How do I reduce load time for this advanced filter

Need help
1

I have an app for approvals, and their are multiple approvers, and not all of them are the same person each time.

What I have done is, I created a table called Tracking. in this table I have a field for User and a field called “To Be Reviewed” which is a list of users as the reviewers may be multiple people. The tracking table links to the main table which is called Approval. In the Approval table, I have a field called List of Trackings

Right now, I am doing the following advanced search. But the issue is that it takes a lot of time to load

This Approvals List of Trackings: each item’s User contains Current User or This Approvals List of Trackings: each item’s To Be Reviewed contains Current User.

1 Like
3

Now that’s a ChatGPT response, if ever I’ve seen one…

5 Likes
4

Any advice on the problem?

5

You may consider rewriting the question as it’s not clear what you’re trying to do or what the schema is…

6

image

This is my search. It takes a long time, how can I better optimize this search?

image

image

Workflow → When button is pressed for an approval, add that user to the tracking data type under the To Be Reviewed list of users with the current page’s approval.

7

Any ideas on how to solve this?