#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.

19mo

Join the chat

Mar 23, 2022 (19 months ago)

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?

Photo of md5-4e872368b2b2668460205b409e95c2ea

Kishore Nallan

12:14 PM

👋 we don't have any restrictions.

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

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

12:21 PM

great. thank you

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 2779 threads (79% resolved)

Join Our Community Manage subscription

Similar Threads

Queries for Specific Index in Array Fields

Joe inquired about searching specific array indexes. Kishore Nallan clarified it's not possible but offered to suggest alternatives.

24mo

Maximum Number of Fields in a Document

Rodrigo inquired about the maximum number of fields a document can have. Kishore Nallan assured there's no limit.

19mo

Querying Documents Using Wildcards and Array Lengths

Orion asks about querying documents with wildcards or array lengths. Jason requests clarification and examples from Orion to better understand the question.

17mo