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
- HTTP POST to function returning "No Appw...
Hi everyone, I’m running into an issue with my self-hosted Appwrite instance. I’ve set up my environment variables (APPWRITE_FUNCTION_PROJECT_ID, APPWRITE_FUNC...
- Can't add dart 3.5 runtime
Modified the `.env` to enable dart 3.5 runtime on my self-hosted instance but still can't find the runtime when creating a new function. I manually pulled the i...
- How to verify an user using AppWrite Fun...
I have seen similar questions but none whose solutions serve me. I have a function to verify a user with their secret and their id: https://blahblah.appwrite.gl...