#community-help

Faceting of `id` and `updated_at` Fields Discussion

TLDR Viktor asked if ids and timestamps should be faceted. SamHendley advised to not facet them unless needed specifically due to performance issues.

Powered by Struct AI
arrow_up

1

6
9mo
Solved
Join the chat
Jan 03, 2023 (9 months ago)
Viktor
Photo of md5-972da58c82de3b38862220702e852eda
Viktor
03:54 PM
Should fields like id and updated_at be marked as facets? I understand facet fields are indexed verbatim, which I suppose makes sense for ids and timestamps
SamHendley
Photo of md5-a9a351e11d64f05b41fec183816a0cda
SamHendley
04:13 PM
be careful using full resolution timestamps in facets
04:17
SamHendley
04:17 PM
TL;DR: faceting performance scales to the number of unique values so a full resolution timestamp can easily mean every document has a unique value.
04:17
SamHendley
04:17 PM
My recommendation is don’t facet times unless you have a specific reason to do so. You can still filter/sort on non faceted data
arrow_up

1

Viktor
Photo of md5-972da58c82de3b38862220702e852eda
Viktor
04:31 PM
Good to know, thanks!