Search Performance in WIX Code

Ask the community
, ,
1

We have a collection which will contain around 60.000 rows.

Each row has tags in a comma separated field and we might want to use the setFilter when people search using tags.

Question, how about performance this way? Or would it be better to store tags in separate collection, search in that and connect them to another collection where there is a relation between tags and items.

What would give us the best performance?

2

you’ll have to test it yourself and see.
my intuition is that having the tags in the same collection as the 60K rows will work better.