#community-help

Query on Performance with Many Fields in Typesense

TLDR John asked about the performance implications of having many fields but only searching on a few in Typesense. Kishore Nallan clarified that all indices are field level and independent.

Powered by Struct AI
4
15mo
Solved
Join the chat
Sep 23, 2022 (15 months ago)
John
Photo of md5-21545f1facb7836c149bc4c70752bd2b
John
10:56 AM
Maybe weird question but I’m curious about the performance implications of having a lot of fields but not searching/filtering/faceting on all of them. For example, you have some normal text fields and then 500 fields where you would only search/filter/facet with one of them at a time. This could be the case for an e-commerce store where the stock status depends on the warehouse, but you don’t want to keep 500 almost entirely duplicate search indices.
10:56
John
10:56 AM
Inituitively I feel like it should be OK, but I know very little about Typesense internals so 😅
(I could of course try this as well but figured someone might already know)
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
11:00 AM
All indices are at a field level. So they are independent.
John
Photo of md5-21545f1facb7836c149bc4c70752bd2b
John
11:09 AM
Great, that’s what I thought 🙂 Thanks