#community-help

Maximum Limit of Strings in Array Field Query

TLDR Tom inquired about the maximum limit for array field queries. Kishore Nallan clarified that no such restrictions exist and performance won't significantly degrade even with thousands of queries.

Powered by Struct AI
5
19mo
Solved
Join the chat
Mar 23, 2022 (19 months ago)
Tom
Photo of md5-53f00937886d836f7deed0a0c17309a3
Tom
12:09 PM
Hey there!

Is there a maximum number of items that could be in a document field string array?

For example, if I had a product with a tags array field - how many tags could I put in that field and still be able to query:
tags:=SOME_TAG

I would assume there is some ceiling, but does anyone know what that number is?
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
12:14 PM
👋 we don't have any restrictions.
Tom
Photo of md5-53f00937886d836f7deed0a0c17309a3
Tom
12:18 PM
awesome. would there be any performance degradation if the field string array size got into the 1,000's?
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
12:20 PM
Don't think so because the array entities get stored as inverted index so length won't have performance impact so long tokens don't repeat too often.
Tom
Photo of md5-53f00937886d836f7deed0a0c17309a3
Tom
12:21 PM
great. thank you