Trying to figure out, in terms of overall doc size and performance, what the better option would be in the following scenario:
Scenario: I have a table with six columns that are lookups, each with different selectable items (about 5 selectable items per column)
- Option 1: Make six different tables with the different select items and have each column pull from the corresponding table.
- Option 2: Make 1 table with 30 rows (5 items per intended column) and then write a filter() into the lookup options so each column is only pulling the correct 5 items.
Any idea which option is a “less expensive” option that would lead to a smaller doc size and faster performance?
Hoping someone like @Paul_Danyliuk can help me out here!