#community-help

Discussing Typesense's Handling of Sparse Indexed Fields

TLDR Adrian questioned how typesense manages sparse indexed fields. Kishore Nallan clarified that absent values aren't stored, optimizing storage and performance.

Powered by Struct AI

1

3
26mo
Solved
Join the chat
Sep 17, 2021 (26 months ago)
Adrian
Photo of md5-0faf10c668e73a12e9a6dcd5682ea60e
Adrian
06:36 AM
Any thoughts on how typesense handles sparse indexed fields? If a collection schema has a lot of fields (like 100) but each individual document only has a couple (<10 fields) actually present, what should I expect from a storage and performance perspective?
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
06:38 AM
Should not be a problem. We don't store a default value or anything for optional values. So it will simply not exist in the inverted index.
Adrian
Photo of md5-0faf10c668e73a12e9a6dcd5682ea60e
Adrian
06:39 AM
cool thanks!

1