Back
Query params are way too limiting in terms of max size
I was trying to list rows in a table that do not already exist in another table. I retrieved around 260 row IDs which are 13 characters in length each, and then used Query.notEqual('$id', rowIds) to query the target table. However, I received this error:
TypeScript
AppwriteException: Invalid `queries` param: Value must a valid array no longer than 100 items and Value must be a valid string and at least 1 chars and no longer than 4096 chars
code: 400,
type: "general_argument_invalid",
response: "{\"message\":\"Invalid `queries` param: Value must a valid array no longer than 100 items and Value must be a valid string and at least 1 chars and no longer than 4096 chars\",\"code\":400,\"type\":\"general_argument_invalid\",\"version\":\"1.8.0\"}",
In my opinion, a character limit of 4096 is way too limiting for any non-trivial queries like this one. I would like to see the database being able to at least handle 500-1000 IDs before throwing the same error.
TL;DR
Developers find the maximum character limit for query params to be too restrictive when making certain types of queries in the database. The error message indicates a limit of 4096 characters, which is causing issues when trying to query with 260 IDs. The developer suggests increasing the limit to be able to handle 500-1000 IDs without errors. Solution: The developer requests the database to handle a higher number of IDs without throwing an error.