I’ve read several times in the forum that doing a search is always preferred to filtering, but what about in this example:
I have 2 data types: User and Item
There are 10,000 Users and 1,000 Items, of which 3 are assigned to the current user. Only 2 of those 3 items are currently ‘Available’ and I want to display the current user’s available items. Should my data source be:
“Do a search for Item’s List of Users where User = Current User”
“Do a search of User’s List of Items where Available = yes”
“Current User’s List of Items:filtered where Available = yes”
Seems to me the last one would be most efficient, no?