Back

Maximum Query array length

  • 0
  • Databases
jordorama
8 Jan, 2024, 19:45

I remember reading the documention and it stating a max array length for Query.equals(key, array) but now I cant find it.

I was trying to query 100 items in the array but was getting an error related to array lengths.

Is there an upper limit to the length of the array?

TL;DR
I'm trying to run a query on a large array of data, but I keep getting an error saying the query exceeds the maximum length. How can I fix this? Reply 1: The maximum query length limit is usually set by the server. You can try changing the server settings to increase the maximum query length. Reply 2: Alternatively, you can split the query into smaller chunks and execute them separately. This way, you can work around the maximum query length limitation. Reply 3: Another approach is to use pagination to retrieve the array data in smaller batches rather than querying the entire array at once. Solution: To fix the
Drake
8 Jan, 2024, 21:06

yes, 100 as the error indicates

Drake
8 Jan, 2024, 21:08

well....it's 100 queries...where each query has a max string of 4096 chars (because the query gets converted to a string like:

TypeScript
equal("attribute",["val1","val2"])
Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more