Advanced Filter - Slowness Help

mohamed.mohamedfaiz · 2024-10-14T13:13:25.890Z

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

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.

tunacardak · 2024-10-14T15:09:47.585Z

Your database structure needs improvement. A tracking object currently contains an approval, and the approval object holds a list of trackings. This design is generally not ideal. Additionally, could you clarify if a user can be associated with multiple tracking → to be reviewed objects?