Last Friday I fixed a bug in one of our server side functions where it became clear that not all records where considered because of pagination. I see the value of pagination when sending data to the client via a REST interface (or something like that), but when I query data on the server it feels kinda wired. In this cases I wanted to get all foreign keys from a certain field of that collection. So I needed to recursively cursor over the whole thing. Is there a way to avoid this?
We use Web/ JS on the client and Node.js in the Functions.
Hi, what is the current size you are working with in pagination?
Default, which is 25. But the problem is always there.
If it's the cloud you can change the limit up to 100 and in the latest version up to 5000
To do so send Query.limit(100) with your request.
But it's recommend you use the pagination for performance and overwhelming your sever.
Recommended threads
- Why does this happen?
`AppwriteException: general_argument_invalid, Invalid `secret` param: Value must be a valid string and at least 1 chars and no longer than 256 chars (400)` the...
- Selfhosted starter python function retur...
I am running a selfhosted appwrite instance. Creating a node function and executing it works just fine but when i try to execute a python starter function, i ge...
- Can't run functions from console in appw...
Hello, I have an appwrite 1.9.0 self hosted, functions run correctly with client SDK or event when using the function domain *.function.mydomain, for testing pu...