Thanks for that explanation and it does help clarify things.
I am basically at a crossroads where I am trying to determine the best way to optimize loading times.
I will try to explain what I am doing and maybe you can provide some feedback.
Let’s say I have a number of “Type” items with a field called parent user. Each item also has field: name and field: category.
Item A - Category 1
Item B - Category 1
Item C - Category 2
Item D - Category 2
Item E - Category 1
Item F - Category 3
and so on.
Now I have 5 repeating groups on the page each which displays a category. So repeating group has a search for item with a constraint of item parent user = current user and another constraint of Category = Category 1, Category 2, etc
Now that might work when the database is small but let’s say there are thousands upon thousands of items. The search for these items would slow down as more and more users add items to the database.
If I give a user a field called List of Items, which would be a list, would it be more efficient to have the repeating groups call the User’s list of items and filter them on each repeating block.
So the repeating block would say User List of Items:Filtered “with constraint, Category = Category 1”
Would this be more efficient then using the search for item with constraint "Parent user = current user, and Category = Category 1 “or 2, etc”
And would the answer change depending on the number of items in the database? Say 1000 total items versus 1,000,000 total items.
I will owe you a cyber bottle of wine for this one.