Query not valid: Invalid limit: Value must be a valid range between 0 and 100 (400)

AppwriteException: general_argument_invalid, Query not valid: Invalid limit: Value must be a valid range between 0 and 100 (400) i want to call more then 5k data in single response how to achieve this in appwrite cloud if there is limit

is anyone is here ?

can you send the code snippet once ?

because AppwriteException: general_argument_invalid, Query not valid: Invalid limit: Value must be a valid range between 0 and 100 (400) returns the same even if the args are wrong sometimes

or atleast i have faced the same problem

The limits can be removed if you're on self-hosted (i think). For the cloud version, I don't think you can get rid of/change the limit

nah nah i have got like between 1 and 200 and kinda worked

lemme verify once

is backup is possible in cloud version ?

not right now.

might be supported in the future, not a 100% certain.

ok,

is there is anyway to get all 5k data in single response

is using function will be good option?

but it will be costly for appwrite 😅

Not on cloud since we removed the max limit in 1.3 and cloud is 1.1.2.

That said, you typically don't want to fetch too many things at once because that loads too much data into memory. That's why it's best to paginate

ok

but what if i want to fetch all data in single response, do i have to use function for this.

Appwrite function is unrelated and probably won't help because the maximum response from an Appwrite function is 4MB or something