Hello!
I am working with a larger dataset (16milion products). In here i have a facet value categoryPaths, this is a StringArray field that contains a number of values and looks for example like this:
[
"demo.store/Media-abc12345",
"demo.store/Media-abc12345/Genres-def67890",
"demo.store/Media-abc12345/Genres-def67890/Pop-ghi11223",
"demo.site/Media-jkl44556",
"demo.site/Media-jkl44556/Genres-mno77889",
"demo.site/Media-jkl44556/Genres-mno77889/Pop-pqr99001"
]
Now the searching with the facets is really slow (12seconds) even when using the facet_sample_percent, facet_sample_threshold and facet_sample_slope.
Do you guys have any recommendation on how this can be improved?
Filtering is also slow, and actually the priority.
Should we use a different collection and join?
Should we only use the codes? And make it an int array?